The Syncfusion Excel Library is a feature-rich and high-performance Blazor Excel library that allows you to add robust Excel functionalities to any Blazor 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.
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.
There are no distribution fees, per-server licensing fees, or royalties, making Excel Library very cost-effective.
It’s easy to migrate existing Office automation code to Excel Library since the APIs are very similar.
The 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.
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.
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.
Easily import data from common data sources, like arrays, data tables, collection objects, and HTML tables, into an Excel worksheet.
Data in an existing worksheet can also be exported to data tables, collection objects, and nested classes.
Data sorting can be performed based on cell value, cell color, and font color using multiple sorting algorithms.
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.
Cell data validations can be applied with operators, alert messages, custom formulas, and drop-down lists.
The built-in calculation engine quickly evaluates formula cell values during runtime. It supports over 400 Excel functions.
Named ranges can be used in formulas as substitutes for cell references. The built-in name manager allows adding, editing, and deleting names.
Import hierarchical data from multiple tables.
Import JPEG, PNG, BMP, TIFF, and GIF images in customized formats.
Apply conditional formats to template marker range with data bars, color scales, and icon sets.
Create and edit all types of Excel charts including Excel 2016 charts.
Create charts with different types of series.
Create a tiny chart in a worksheet cell that provides visual representation of data.
Chart-to-image conversion is supported only in Blazor server-side, and it can be achieved using just a few lines of code.
Use data bars to easily spot larger and smaller numbers.
Use color scales to create visual effects for comparing a cell value with values in a range of cells.
Icon sets distinguish data in three or five categories based on the threshold value.
Excel Library supports various formatting options like number formats, alignments, font settings, borders, colors, and rich text that make data more readable.
Create custom styles or apply built-in styles to cell ranges or tables.
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.
Customize page settings like orientation, paper size, scaling, margins, print area, print titles, and the header and footer.
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 supported. Layout and inline formatting are also supported in all the three formats (compact, outline, and tabular).
Create pivot charts from pivot tables to visualize summarized data with legends, data labels, chart titles, axis titles, and more.
Convert Excel documents to HTML, images, and JSON. Chart-to-image conversion is supported only in Blazor server-side.
Read and write password-protected Excel documents with various algorithms like SHA 128, SHA256, or SHA512.
Enable and disable workbook and worksheet protections and locked cells.
Create and edit text boxes, option buttons, check-boxes, and combo box controls to enable user-friendly worksheets.
Create and edit 150+ AutoShapes in Excel.
Create and edit comment shapes with rich-text format and various fill options including gradient styles.
|Features||Blazor WASM||Blazor Server|
|Excel elements: text, images, tables, auto filters, data sorting, hyperlinks, data validation, conditional formatting, formulas, pivot tables, comments, shapes, charts, grouping, page settings, and more.|
|Presentation formatting: text, tables, conditional formatting, styles.|
|Create an Excel workbook from scratch.|
|Open an existing Excel workbook and edit.|
|Read worksheets on demand when Excel file contains multiple worksheets.|
|Import data from data tables, data columns, data views, arrays, collection objects, and HTML tables to worksheets.|
|Import data into a preformatted template using template markers.|
|Export data from a worksheet to collection objects.|
|Export data from a worksheet to data table by triggering an event to skip any row, change any value, and continue without any action.|
|Access or modify built-in document properties.|
|Read and write Excel formulas.|
|Encryption and decryption.|
|Find and replace text.|
|Add or copy worksheets within or across workbooks.|
|Copy a range to another range across worksheets.|
|Move a range to another range across worksheets.|
|Save a chart as an image.|
|File formats||Blazor WASM||Blazor Server|
|Excel 97-2003 formats (*.XLS, *.XLT)|
|Excel 2007 and above formats (*.XLSX, *.XLTX, *.XLSM)|
|XML Spreadsheet 2003 (*.XML)|
|Excel to PDF|
|Excel to HTML|
|Worksheet to image (PNG, JPEG)|
|Excel to JSON|
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.