You can create, read, and edit Microsoft Excel files in any.NET application using this framework's creation and editing library. It provides a spreadsheet UI control with Excel-like features to create, edit, view, and format Excel documents.
Excel Library’s top features are charts, formulas, tables, pivot tables, data validation, data import and export, conditional formatting, and security.
80+ charts are supported by the Excel Library to visualize data. Excel charts can be created and modified using the Excel Library (Essential XlsIO) either inside a workbook or as a chart worksheet.
Excel Library is optimized for use in server environments where speed and memory usage are critical.
All the elements in a typical Excel document, such as text, formatting, images, shapes, and tables, are accessible via a comprehensive set of APIs.
On the market for more than 15 years, Syncfusion's Excel Library is a mature and proven tool. It includes extensive documentation, knowledge bases, and sample code.
More than 400 Excel functions are supported. Excel Library also supports add-in functions, external formulas, and an array of formulas.
These real-world examples demonstrate the supported features and APIs for utilizing the Excel Framework to do various Excel-related activities like create, edit, view, convert, and compress.
When you embed XML data in a document, it is referred to as a custom XML part. These are used to store arbitrary XML data in a workbook.
Utilize direct support from our document processing libraries development team along with live chat support with no additional charges.
In G2, more than 400 users have positively reviewed Syncfusion. Other vendors have far fewer reviews.
Get free, unlimited access to the over 1,800 controls in Syncfusion Essential Studio through the Community License if eligible. No credit card required.
You can create, read, and edit Microsoft Excel files in any.NET application using this framework's creation and editing library. It provides a spreadsheet UI control with Excel-like features to create, edit, view, and format Excel documents.
Excel Library’s top features are charts, formulas, tables, pivot tables, data validation, data import and export, conditional formatting, and security.
80+ charts are supported by the Excel Library to visualize data. Excel charts can be created and modified using the Excel Library (Essential XlsIO) either inside a workbook or as a chart worksheet.
Excel Library is optimized for use in server environments where speed and memory usage are critical.
All the elements in a typical Excel document, such as text, formatting, images, shapes, and tables, are accessible via a comprehensive set of APIs.
On the market for more than 15 years, Syncfusion's Excel Library is a mature and proven tool. It includes extensive documentation, knowledge bases, and sample code.
More than 400 Excel functions are supported. Excel Library also supports add-in functions, external formulas, and an array of formulas.
These real-world examples demonstrate the supported features and APIs for utilizing the Excel Framework to do various Excel-related activities like create, edit, view, convert, and compress.
When you embed XML data in a document, it is referred to as a custom XML part. These are used to store arbitrary XML data in a workbook.
Utilize direct support from our document processing libraries development team along with live chat support with no additional charges.
In G2, more than 400 users have positively reviewed Syncfusion. Other vendors have far fewer reviews.
Get free, unlimited access to the over 1,800 controls in Syncfusion Essential Studio through the Community License if eligible. No credit card required.
Syncfusion’s Excel Library is a high-performance .NET Excel library that allows users to create, read, edit, and protect Excel documents in .NET applications without Microsoft Office or interop dependencies.
Platforms | Syncfusion | Other Vendors |
|---|---|---|
WinForms |
|
|
WPF |
|
|
UWP |
|
|
ASP.NET Core |
|
|
ASP.NET MVC |
|
|
WinUI |
|
|
.NET MAUI |
|
|
Blazor |
|
|
Xamarin |
|
|
Linux |
|
|
Azure |
|
|
Amazon Web Services |
|
|
Docker |
|
|
Mac |
|
|
Console |
|
|
Features | Syncfusion | Other Vendors |
|---|---|---|
Web installer |
|
|
Offline installer |
|
|
Linux installer |
|
|
Components | Syncfusion | Other Vendors |
|---|---|---|
Create new excels |
|
|
Open and edit existing workbooks |
|
|
Loading & saving workbooks |
|
|
Opening an existing workbook from Stream |
|
|
Saving a Excel workbook to file system |
|
|
Saving a Excel workbook to stream |
|
|
Closing a workbook |
|
|
Features | Syncfusion | Other Vendors |
|---|---|---|
Create a Worksheet |
|
|
Access a Worksheet |
|
|
Remove a Worksheet |
|
|
Move or Copy a Worksheet |
|
|
Highlight Worksheet Tabs |
|
|
Freeze and Unfreeze Panes |
|
|
Split Panes |
|
|
Page Setup Settings |
|
|
Show or Hide Worksheet |
|
|
Activate a Worksheet |
|
|
Show or Hide Worksheet Tabs |
|
|
Show or Hide Row and Column Headers |
|
|
Show or Hide Grid Lines |
|
|
Set Zoom Level |
|
|
Save Worksheet as CSV |
|
|
Save worksheet as text (*.txt) |
|
|
Save Worksheet as HTML |
|
|
Features | Syncfusion | Other Vendors |
|---|---|---|
Excel to PDF |
|
|
Excel to Image |
|
|
Excel to HTML |
|
|
Excel to ODS |
|
|
Chart to Image |
|
|
Excel to JSON |
|
|
Excel to CSV |
|
|
Features | Syncfusion | Other Vendors |
|---|---|---|
Import Data from DataTable, DataColumn, DataView, Collection Objects |
|
|
Import Data from Nested Collection Objects, Array |
|
|
Exporting from Worksheet to Data Table, Collection Objects |
|
|
Export to Data Table with an Event |
|
|
Export data from Excel to Nested Class Objects |
|
|
Importing Data from Microsoft Grid Controls to Worksheet. DataGrid, Grid View, DataGrid View |
|
|
Import HTML Table |
|
|
Import HTML Table with formula |
|
|
Features | Syncfusion | Other Vendors |
|---|---|---|
Create a Style |
|
|
Set Default Style for row or column |
|
|
Apply Global Style |
|
|
Apply Number Formats |
|
|
Apply Number Formats |
|
|
Apply Cell Text Alignment |
|
|
Merging and Un-Merging Cells |
|
|
Apply Wrap Text |
|
|
Auto-Fit Rows or Columns |
|
|
HTML String Formatting |
|
|
Applying HTML String |
|
|
Supported Tags |
|
|
Rich-Text Formatting |
|
|
Format Cells using GetStyle and SetStyle Methods |
|
|
Using Microsoft Excel 2007 Predefined Styles |
|
|
Formatting Selected Characters in a Cell |
|
|
Formatting Rows and Columns |
|
|
Number setting |
|
|
Alignment setting |
|
|
Font Settings |
|
|
Border Settings |
|
|
Fill Settings |
|
|
Format and Modify Named Ranges |
|
|
Modify an Existing Style |
|
|
Excel Themes and Colors |
|
|
Access and Update the Portions of Rich Text of Cell |
|
|
Merging and Unmerging Cells |
|
|
Features | Syncfusion | Other Vendors |
|---|---|---|
Using Built-in Functions |
|
|
Using Add-in Functions |
|
|
Using Array Formula |
|
|
Using R1C1 Formula |
|
|
Enable and Disable Calculation |
|
|
Writing a Formula |
|
|
Formula with Cross-sheet References |
|
|
Reading a Formula |
|
|
Accessing a Calculated value |
|
|
Applying Argument Separators Based on Cultures |
|
|
Incremental Formula |
|
|
External Formula |
|
|
Calculated Column |
|
|
Defined Names |
|
|
Named Ranges in Formulas |
|
|
Deleting Named Ranges |
|
|
Formula Auditing |
|
|
Calculation Engine |
|
|
Calculate Options |
|
|
Calculation Modes |
|
|
Recalculate Before Save |
|
|
Iteration |
|
|
Features | Syncfusion | Other Vendors |
|---|---|---|
Charts |
|
|
Tables |
|
|
Conditional formatting |
|
|
Pivot Table |
|
|
Pivot Chart |
|
|
Form controls |
|
|
Template Markers |
|
|
Data sorting |
|
|
Data filtering |
|
|
Hyperlinks |
|
|
Shapes |
|
|
Comments |
|
|
Combine workbooks |
|
|
Find and replace |
|
|
Sparkline |
|
|
Slicers |
|
|
Working with Macros |
|
|
Headers, Footers |
|
|
What if analysis |
|
|
Migration from Office Automation to Syncfusion XlsIO |
|
|
Components | Syncfusion | Other Vendors |
|---|---|---|
ASP.NET Core Spreadsheet |
|
|
ASP.NET MVC Spreadsheet |
|
|
Angular Spreadsheet |
|
|
Vue Spreadsheet |
|
|
React Spreadsheet |
|
|
JavaScript Spreadsheet |
|
|
WPF Spreadsheet |
|
|
WinForms Spreadsheet |
|
|
UWP Spreadsheet |
|
|
Features | Syncfusion | Other Vendors |
|---|---|---|
Open and save large Excel files in less time |
|
|
Import and edit existing Excel files Excel files |
|
|
Spreadsheet supports Sparkline and charts |
|
|
400 Excel-compatible formulas |
|
|
80+ Charts |
|
|
Number formatting |
|
|
Conditional formatting |
|
|
Data virtualization |
|
|
Excel version | Syncfusion | Other Vendors |
|---|---|---|
Microsoft Excel 97-2003 |
|
|
Microsoft Excel 2007 |
|
|
Microsoft Excel 2010 |
|
|
Microsoft Excel 2013 |
|
|
Microsoft Excel 2016 |
|
|
Microsoft Excel 2019 |
|
|
Microsoft 365 |
|
|
Our Excel Library is fast, easy to use, and its documentation contains lots of examples.
Features | Syncfusion | Other Vendors |
|---|---|---|
Top features: charts, formulas, tables, pivot tables, data validation, data import and export, conditional formatting, and security. |
|
|
Excel elements: text, images, auto filters, data sorting, hyperlinks, data validation, comments, shapes, search, find and replace, grouping, page settings, and more. |
|
|
Compatible with Excel versions 97 to 2019. |
|
|
Access or modify built-in document properties. |
|
|
Encryption and decryption. |
|
|
Powerful and comprehensive API. |
|
|
Custom XML support. |
|
|
Read and write Excel formulas. |
|
|
Apply or modify Excel formula auditing settings. |
|
|
Auto-fit rows and columns. |
|
|
More than 400 Excel functions supported. |
|
|
Data validation list. |
|
|
Compared to competitors, Syncfusion’s Excel Library has many unique features that benefit users.
Features | Syncfusion | Other Vendors |
|---|---|---|
Supported platforms: UWP |
|
|
Viewer Control: Vue Spreadsheet, UWP Spreadsheet |
|
|
Compatible Microsoft Excel Versions: Microsoft 365 |
|
|
80+ charts. |
|
|
Smart markers. |
|
|
Global style. |
|
|
Tags support. |
|
|
Formula with cross-sheet references. |
|
|
Calculation modes. |
|
|
Find query tables and list objects related to external data connections. |
|
|
Convert tables to ODS. |
|
|
Set pivot table to show empty cells. |
|
|
Customize globalization settings for pivot tables. |
|
|
Find and refresh nested or children pivot tables of parent pivot tables. |
|
|
Detect file format of encrypted Office Open XML - OOXML files. |
|
|
Watch interactive Excel Library demos with problem-solving ideas that will reduce your development time.Â
Features | Syncfusion | Other Vendors |
|---|---|---|
Read and write Excel files from C# with 5 lines of code. |
|
|
Real-world examples |
|
|
Single API across all platforms. |
|
|
Source code with preview. |
|
|
Github samples |
|
|
All the features of our Excel Library components are explained thoroughly with C# code examples, demos, and screenshots in the documentation.Â
Features | Syncfusion | Other Vendors |
|---|---|---|
Installation and Upgrade information. |
|
|
System Requirements. |
|
|
Individual Nuget Packages. |
|
|
All features explained with extensive documentation and knowledge base. |
|
|
Every feature explained with code examples. |
|
|
Release history. |
|
|
Request feature. |
|
|
Essential XlsIO is a native .NET class library that can easily integrate Microsoft Excel files.Â
Features | Syncfusion | Other Vendors |
|---|---|---|
Powerful and comprehensive API. |
|
|
Proven and fully documented. |
|
|
Blazing-fast performance. |
|
|
No server deployment fees. |
|
|
Live chat support on all business days. |
|
|
Having an excellent set of tools and a great support team, Syncfusion reduces customers’ development time. Here are some of their experiences.
Explore our 200+ free ebooks to learn about the latest trends in software development.
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.
Fax: +1 919.573.0306
US: +1 919.481.1974
UK: +44 20 7084 6215
Toll Free (USA):
1-888-9DOTNET
