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

Blazor Excel Library - Overview

The Syncfusion Excel Library (Essential XlsIO) 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.

Overview diagram of Blazor 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

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.

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.

Import data

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

Export data.

Export data

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

Sorting.

Sorting

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

Filters.

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.

Data validation

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


Efficient calculations

Built-in functions.

Built-in functions

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

Named ranges.

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.

Import hierarchical data

Import hierarchical data from multiple tables.

Import images.

Import images

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

Dynamic formatting.

Dynamic formatting

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


Excel charting

Chart types.

80+ chart types

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

Custom charts.

Custom charts

Create charts with different types of series.

Sparklines.

Sparkline

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

Charts to images.

Charts to images

Chart-to-image conversion is supported only in Blazor server-side, and it can be achieved using just a few lines of code.


Conditional formatting

Data bars.

Data bars

Use data bars to easily spot larger and smaller numbers.

Color scales.

Color scales

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

Icon sets.

Icon sets

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


Excel formatting

Formatting options.

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.

Styles

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

Row and column manipulation.

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.

Page setup

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


Pivot

Pivot tables.

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 documents.

Convert Excel documents

Convert Excel documents to HTML and images. Chart-to-image conversion is supported only in Blazor server-side.


Security

Encryption and decryption.

Encryption and decryption

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

Excel protection.

Protection

Enable and disable workbook and worksheet protections and locked cells.


Shapes

Form controls.

Form controls

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

AutoShapes.

AutoShapes

Create and edit 150+ AutoShapes in Excel.

Comments.

Comments

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


Feature matrix

Features Blazor Client-Side Blazor Server-Side
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. Yes Yes
Presentation formatting: text, tables, conditional formatting, styles. Yes Yes
Create an Excel workbook from scratch. Yes Yes
Open an existing Excel workbook and edit. Yes Yes
Read worksheets on demand when Excel file contains multiple worksheets. Yes Yes
Import data from DataTable, DataColumn, DataView, Array, collection Objects to worksheets. Yes Yes
Import data into a preformatted template using template markers. Yes Yes
Export data from a worksheet to DataTable and collection Objects. Yes Yes
Access or modify built-in document properties. Yes Yes
Read and write Excel formulas. Yes Yes
Encryption and decryption. Yes Yes
Find and replace text. Yes Yes
Add or copy worksheets within or across workbooks. Yes Yes
Copy a range to another range across worksheets. Yes Yes
Move a range to another range across worksheets. Yes Yes
Save a chart as image. No Yes
File formats Blazor Client-Side Blazor Server-Side
Open Save Open Save
Excel 97-2003 formats (*.XLS, *.XLT) Yes Yes Yes Yes
Excel 2007 and above formats (*.XLSX, *.XLTX, *.XLSM) Yes Yes Yes Yes
XML Spreadsheet 2003 (*.XML) Yes Yes Yes Yes
CSV Yes Yes Yes Yes
Excel to PDF N/A No N/A Yes
Excel to HTML N/A Yes N/A Yes
Worksheet to Image (PNG, JPEG) N/A Yes N/A 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
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.