We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. (Last updated on: November 16, 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

Trusted by the world’s leading companies

Syncfusion Trusted Companies

.NET Core Excel Library - Overview

The Syncfusion Excel Library (Essential XlsIO) is a feature-rich and high-performance .NET Core Excel library that allows you to add robust Excel functionalities to any .NET Core application. It allows you to create, read, and edit Excel documents programmatically without Microsoft Office dependencies. This library also offers functionality to import and export data, visualize data as charts, tabulate data, calculate with simple and complex formulas, format cells and values, sort and filter data, protect Excel files, and more.

Overview diagram of .NET Core Excel Library.


General information

Blazing-fast performance

Optimized for a server environment where speed and low memory usage are critical. It works much faster and consumes less memory than Office automation libraries.

No server deployment fees

There are no distribution fees, per-server licensing fees, or royalties, making Excel Library very cost-effective.

Easy migration from Office automation

It’s easy to migrate existing Office automation code to Excel Library since the APIs are very similar.

Compatible with Excel versions 97 to 2019

This library reads and writes all popular Excel file formats including XLS and XLSX. A file can be opened in one format and saved in another format.

Powerful and comprehensive API

The comprehensive API makes it possible to create richly formatted Excel files with elements like text, numbers, formatting, images, charts, and pivot tables. It is also possible to extract any desired piece of information from an existing workbook.

Start reports with Excel and finish with Excel Library

Reports can be designed using Microsoft Excel, and Excel Library can be used to dynamically populate them with data. Final reports can then be saved to an Excel file or exported to other supported formats.


Data

Import data feature in .NET Core Excel Library.

Import data

Easily import data from common data sources like arrays, data tables, and collection objects into an Excel worksheet.

Export data feature in .NET Core Excel Library.

Export data

Data in an existing worksheet can also be exported to data tables, collection objects and nested classes.

Sorting feature in .NET Core Excel Library.

Sorting

Data sorting can be performed based on cell value, cell color, and font color using multiple sorting algorithms.

Filters feature in .NET Core Excel Library.

Filters

Excel Library supports various filter options like Top, Top10, and Percent, with different filter types such as custom, combination, dynamic, color, icon, and advanced filters.

Data validation feature in .NET Core Excel Library.

Data validation

Cell data validations can be applied with operators, alert messages, custom formulas, and drop-down lists.


Efficient calculations

Built-in functions feature in .NET Core Excel Library.

Built-in functions

The built-in calculation engine quickly evaluates formula cell values during runtime. It supports over 400 Excel functions.

Named ranges feature in .NET Core Excel Library.

Named ranges

Named ranges can be used in formulas as substitutes for cell references. The built-in name manager allows adding, editing, and deleting names.


Template markers

Import hierarchical data feature in .NET Core Excel Library.

Import hierarchical data

Import hierarchical data from multiple tables.

Import images feature in .NET Core Excel Library.

Import images

Import images like JPEG, PNG, BMP, TIFF, and GIF in customized formats.

Dynamic formatting feature in .NET Core Excel Library.

Dynamic formatting

Apply conditional formats to a template marker range with data bars, color scales, and icon sets.


Excel charting

Chart types feature in .NET Core Excel Library.

80+ chart types

Create and edit all types of Excel charts, including Excel 2016 charts.

Custom charts feature in .NET Core Excel Library.

Custom charts

Create charts with different types of series.

Sparklines feature in .NET Core Excel Library.

Sparkline

Create a tiny chart in a worksheet cell that provides visual representation of data.

Chart-to-image feature in .NET Core Excel Library.

Charts to images

Charts can also be converted to images using just a few lines of code.


Conditional formatting

Data bars feature in .NET Core Excel Library.

Data bars

Use data bars to easily spot larger and smaller numbers.

Color scales feature in .NET Core Excel Library.

Color scales

Use color scales to create visual effects for comparing the cell value with values in a range of cells.

Icon sets feature in .NET Core Excel Library.

Icon sets

Icon sets distinguish data in three or five categories based on the threshold value.


Excel formatting

Formatting options feature in .NET Core Excel Library.

Formatting options

Excel Library supports various formatting options like number formats, alignments, font settings, borders, colors, and rich text that make data more readable.

Styles feature in .NET Core Excel Library.

Styles

Create custom styles or apply built-in styles to cell ranges or tables.

Row and column manipulation feature in .NET Core Excel Library.

Row and column manipulation

Excel Library performs various cell-level operations like resizing rows and columns, hiding and showing rows and columns, adding or deleting rows and columns, grouping and ungrouping, and subtotaling.

Page setup feature in .NET Core Excel Library.

Page setup

Enable page settings like orientation, paper size, scaling, margins, print area, print titles, and the header and footer.


Pivot

Pivot tables feature in .NET Core Excel Library.

Pivot tables

Create and edit pivot tables and pivot charts with just a few lines of code. General filter options, such as page filters, row filters, and column filters, with various pivot table visibility settings and custom sorting, are also supported.

Pivot charts.

Pivot charts

Create pivot charts from pivot tables to visualize summarized data with legends, data labels, chart titles, axis titles, and more.


Conversion

Convert Excel feature in .NET Core Excel Library.

Convert Excel

Convert Excel documents to ODS, HTML, and images. Excel charts can also be converted to images.


Security

Encryption and decryption feature in .NET Core Excel Library.

Encryption and decryption

Read and write password-protected Excel documents with various algorithms like SHA 128, SHA256, or SHA512.

Excel protection feature in .NET Core Excel Library.

Protection

Enable and disable workbook and worksheet protections and locked cells.


Shapes

Form controls feature in .NET Core Excel Library.

Form controls

Create and edit text box, option button, check box, and combo box controls to enable user-friendly worksheets.

AutoShapes feature in .NET Core Excel Library.

AutoShapes

Create and edit 150+ AutoShapes in Excel.

Comments feature in .NET Core Excel Library.

Comments

Create and edit comment shapes with rich-text format and various fill options, including gradient styles.


Feature matrix

Workbook Features XLSX XLS
Create an Excel workbook from scratch or modify an existing workbook. Yes Yes
Open an existing Excel workbook from a file system or stream. Yes Yes
Save an Excel workbook to a local file or stream, or stream it to the client browser. Yes Yes
Read worksheets on demand when an Excel file contains multiple worksheets. Yes Yes
Hide and unhide worksheets. Yes Yes
Add or extract custom XML documents. Yes Yes
Add or modify document properties. Yes Yes
Import and Export XLSX XLS
Import data from data tables, data columns, data views, arrays, and collection objects to a worksheet. Yes Yes
Import data into a preformatted template using template markers. Yes Yes
Importing large amounts of data with minimal memory consumption using the import-on-save option. Yes Yes
Export data from worksheet to data table. Yes Yes
Export data from worksheet to collection objects. Yes Yes
Import or export hyperlinks. Yes Yes
Formulas XLSX XLS
Read and write Excel formulas. Yes Yes
Add or modify named ranges in workbook and worksheet levels. Yes Yes
Perform calculation for a range of cells using named ranges. Yes Yes
Apply or modify Excel formula auditing settings. Yes Yes
Enable automatic and manual calculation options. Yes Yes
Trace the relationships between the cells and formulas through dependent and precedent ranges. Yes Yes
Charts XLSX XLS
Creation and manipulation of Excel 2D charts. Yes Yes
Creation and manipulation of Excel 3D charts. Yes Yes
Creation and manipulation of custom charts. Yes Yes
Creation and manipulation of sparklines. Yes NA
Creation and manipulation of Excel 2016 charts. Yes NA
Pivot Tables
Creation and manipulation of pivot tables (while saving as XLS format, the pivot table is preserved as-is from the input XLS file). Yes No
Apply various pivot table settings like page filter, row filter, and column filter (while saving as XLS format, pivot table is preserved as-is from the input XLS file). Yes No
Supports pivot table settings such as visibility of field list, collapse button, field caption and field option, and header captions. Yes No
Apply custom sorting and direction sorting for pivot table fields. Yes No
Worksheet Features XLSX XLS
Formatting
Creation and manipulation of conditional formatting (supports icon sets, data bars, color scales, specific date in XLSX, and formats unique/duplicate values). Yes Yes
Auto fit or resize rows and columns. Yes Yes
Apply or modify number formats. Yes Yes
Apply or modify fill settings. Yes Yes
Apply or modify font settings. Yes Yes
Apply or modify cell border settings. Yes Yes
Apply or modify all the cell text alignments. Yes Yes
Excel 2007 themes. Yes Yes
Copy/Paste
Add or copy worksheets within or across workbooks. Yes Yes
Copy a range to another range across worksheets. Yes Yes
Copy a range with different copy options. Yes Yes
Move a range to another range across worksheets. Yes Yes
Data
Creation and manipulation of data validation. Yes Yes
Apply or modify AutoFilters to filter worksheet data. Yes Yes
Apply or modify color or icon filters to filter worksheet data. Yes Yes
Apply or modify data sorting. Yes Yes
Find and replace data. Yes Yes
Row/Column Manipulation
Apply and modify view settings to freeze, unfreeze, and split panes. Yes Yes
Hide and unhide rows and columns. Yes Yes
Merge and unmerge cells. Yes Yes
Insert
Insert and delete images in worksheets. Yes Yes
Apply or modify a background image in a worksheet. Yes Yes
Add, remove, and modify hyperlinks. Yes Yes
Group or ungroup rows and columns. Yes Yes
Add or modify subtotals of grouped data. Yes Yes
Add and delete OLE objects. Yes No
Security
Open and save encrypted and decrypted documents. Yes Yes
Protect and unprotect workbooks. Yes Yes
Protect and unprotect worksheets. Yes Yes
Lock and unlock cells for write protection. Yes Yes
Page Setup
Set and get header and footer settings. Yes Yes
Apply and modify horizontal and vertical page breaks. Yes Yes
Apply and modify custom page breaks. Yes Yes
Apply various page setup options like paper size, orientation, scaling, and margins. Yes Yes
Apply print settings. Yes Yes
Print workbook with custom page settings. Yes Yes
Shapes
Creation and manipulation of autoshapes. Yes Yes
Creation and manipulation of check boxes. Yes Yes
Creation and manipulation of combo boxes. Yes Yes
Creation and manipulation of comments. Yes Yes
Creation and manipulation of text boxes. Yes Yes
Creation and manipulation of group shapes. Yes Yes
Miscellaneous
Preserve Macros Yes Yes
Conversion XLSX XLS
Convert an entire Excel worksheet into a single image. Yes Yes
Convert specific range of an Excel worksheet into a single image. Yes Yes
Convert Excel charts to images (.NET Framework 4.0 and above). Yes Yes
Convert Excel document to ODS (Open Document Spreadsheet). Yes Yes

PRICING

File Formats
Developer Platform
Unlimited Global License

Developer Platform

Essential Studio

$ 2,495

/developer 1st year

Includes 1000+ Controls
Best Value

Unlimited Global License

Cover everyone in your organization for one low annual fee

CONTACT US

File Formats

$ 995

/developer 1st year

DEVELOPER PLATFORM
  • 60+ Controls each for JavaScript, Angular, Blazor, React, and Vue.
  • 75+ ASP.NET Web Forms Controls
  • 65+ ASP.NET MVC Controls
  • 65+ ASP.NET Core Controls
  • File Formats (Word, Excel, PowerPoint and PDF) Tool tip information icon
  • Bold Report Viewer SDK
  • 135+ Xamarin Controls *Includes iOS, Android and UWP
  • 100+ WinForms Controls
  • 90+ WPF Controls
  • 70+ UWP Controls
  • 55+ PHP Controls
  • 55+ JSP Controls
  • Flutter Widgets
  • Predictive Analytics
SUPPORT
  • Dedicated Account Representative
  • Quarterly product releases
  • Support within 24 hours on all business days
LICENSING
  • Licensing Management Portal
  • Commercial Use
  • Max Developer count
  • 1 per license
  • Coverage Period
  • 1 year
File Formats
Developer Platform
Unlimited Global License

RESOURCES

CASE STUDY

Syncfusion’s file format components helped me create the reports I needed, fast. – J. Pereira, Software Developer.

The libraries have been built from scratch and refined for more than a decade to provide blazing-fast performance, comprehensive API, and compatibility across the latest and older versions of these files.

CONTINUE READING View all Customer Stories

VIDEOS

Syncfusion File Format Libraries - Manipulate Excel, Word, PowerPoint, and PDF files

Read and write Excel, Word, PDF, and PowerPoint files. Also includes integrated visualization capabilities. Advanced features include support for pivot tables, pivot charts, mail-merge, and extensive formatting.

E-BOOK

Succinctly Series: Statistics Using Excel Succinctly

Succinctly Series: Statistics Using Excel Succinctly


- by Charles Zaiontz
CONTINUE READING View all E-books

Awards

Greatness—it’s one thing to say you have it, but it means more when others recognize it. Syncfusion is proud to hold the following industry awards.

Syncfusion Awards
Scroll up icon

You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.