Supported Features by Platforms
9 Jan 202515 minutes to read
The list of various supported and non-supported Excel features of Essential® XlsIO in different platforms is given in this section.
Supported Features by .NET Framework and .NET Standard
The list of supported and non-supported Excel features in .NET Framework and .NET Standard is given below.
Workbook Features | .NET Framework (WF, WPF, ASP.NET and ASP.NET MVC) |
.NET Standard (UWP, .NET Core and Xamarin) |
---|---|---|
Create an Excel workbook from scratch or modify an existing workbook. | ![]() |
![]() |
Open an existing Excel workbook from file system or stream. | ![]() |
![]() |
Save Excel workbook to a local file, stream, or stream it to a client browser. | ![]() |
![]() |
Read worksheets on demand when Excel file contains multiple worksheets. | ![]() |
![]() |
Hide and unhide worksheets. | ![]() |
![]() |
Add or extract custom XML documents. | ![]() |
![]() |
Add or modify document properties. | ![]() |
![]() |
Import and Export | .NET Framework (WF, WPF, ASP.NET and ASP.NET MVC) |
.NET Standard (UWP, .NET Core and Xamarin) |
---|---|---|
Import data from DataTable, DataColumn, DataView, Array to worksheet. | ![]() |
![]() |
Import data from collection objects to worksheet. | ![]() |
![]() |
Import data from nested collection objects to worksheet. | ![]() |
![]() |
Import data into a pre-formatted template using Template Markers. | ![]() |
![]() |
Importing large amounts of data with minimal memory consumption can be achieved using the import on save option. | ![]() |
![]() |
Export data from worksheet to datatable and collection objects. | ![]() |
![]() |
Export data from worksheet to nested class. | ![]() |
![]() |
Imports data from various external sources like Microsoft Access, SQL Server and Excel, which maintain the connection to refresh data dynamically. | ![]() |
![]() |
Formulas | .NET Framework (WF, WPF, ASP.NET and ASP.NET MVC) |
.NET Standard (UWP, .NET Core and Xamarin) |
---|---|---|
Read and write Excel formulas. | ![]() |
![]() |
Add or modify named ranges in workbook and worksheet levels. | ![]() |
![]() |
Performs calculation for a range of cells using named ranges. | ![]() |
![]() |
Apply or modify Excel formula auditing settings. | ![]() |
![]() |
Enable automatic and manual calculation options. | ![]() |
![]() |
Charts | .NET Framework (WF, WPF, ASP.NET and ASP.NET MVC) |
.NET Standard (UWP, .NET Core and Xamarin) |
---|---|---|
Creation and manipulation of Excel 2-D charts. | ![]() |
![]() |
Creation and manipulation of Excel 3-D charts. | ![]() |
![]() |
Creation and manipulation of custom charts. | ![]() |
![]() |
Creation and manipulation of sparklines. | ![]() |
![]() |
Creation and manipulation of Excel 2016 charts. | ![]() |
![]() |
Pivot Tables | ||
Creation and manipulation of pivot tables (while saving as XLS format, the pivot table is preserved as it is from the input XLS file). | ![]() |
![]() |
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). | ![]() |
![]() |
Supports pivot table settings such as visibility of field list, collapse button, field caption and field option, header captions, etc. | ![]() |
![]() |
Security | .NET Framework (WF, WPF, ASP.NET and ASP.NET MVC) |
.NET Standard (UWP, .NET Core and Xamarin) |
---|---|---|
Open and save encrypted and decrypted documents. | ![]() |
![]() |
Protect and unprotect workbook. | ![]() |
![]() |
Protect and unprotect worksheets. | ![]() |
![]() |
Lock and unlock cells for write protection. | ![]() |
![]() |
Worksheet Features | .NET Framework (WF, WPF, ASP.NET and ASP.NET MVC) |
.NET Standard (UWP, .NET Core and Xamarin) |
---|---|---|
Formatting | ||
Creation and manipulation of conditional formatting (supports icon sets, data bars, color scales, and specific date in XLSX). | ![]() |
![]() |
Auto fit or resize rows and columns. | ![]() |
![]() |
Apply or modify number formats. | ![]() |
![]() |
Apply or modify fill settings. | ![]() |
![]() |
Apply or modify font settings. | ![]() |
![]() |
Apply or modify cell border settings. | ![]() |
![]() |
Apply or modify all the cell text alignments. | ![]() |
![]() |
Excel 2007 themes. | ![]() |
![]() |
Copy/Paste | ||
Add or copy worksheets within or across workbooks. | ![]() |
![]() |
Copy a range to another range across worksheets. | ![]() |
![]() |
Copy a range with different copy options. | ![]() |
![]() |
Move a range to another range across worksheets. | ![]() |
![]() |
Data | ||
Creation and manipulation of data validation. | ![]() |
![]() |
Apply or modify AutoFilters to filter worksheet data. | ![]() |
![]() |
Apply or modify data sorting. | ![]() |
![]() |
Find and replace data. | ![]() |
![]() |
Row/Column Manipulation | ||
Apply or modify view settings to freeze, unfreeze, and split panes. | ![]() |
![]() |
Hide or unhide rows and columns. | ![]() |
![]() |
Merge and unmerge cells. | ![]() |
![]() |
Auto-Fit Rows and Columns. | ![]() |
![]() |
Insert | ||
Insertion and deletion of images in worksheets. | ![]() |
![]() |
Apply or modify background image in a worksheet. | ![]() |
![]() |
Add, remove and modify hyperlinks. | ![]() |
![]() |
Group or ungroup rows and columns. | ![]() |
![]() |
Add or modify subtotals of grouped data. | ![]() |
![]() |
Addition and deletion of OLE objects. | ![]() |
![]() |
Page Setup | ||
Get or set header and footer settings. | ![]() |
![]() |
Apply or modify horizontal and vertical page breaks. | ![]() |
![]() |
Apply or modify custom page breaks. | ![]() |
![]() |
Apply various page setup options like paper size, orientation, scaling, margins, etc. | ![]() |
![]() |
Apply print settings. | ![]() |
![]() |
Shapes | ||
Creation and manipulation of AutoShapes. | ![]() |
![]() |
Creation and manipulation of check boxes. | ![]() |
![]() |
Creation and manipulation of combo boxes. | ![]() |
![]() |
Creation and manipulation of comments. | ![]() |
![]() |
Creation and manipulation of text boxes. | ![]() |
![]() |
Miscellaneous | ||
Preserve Macros | ![]() |
![]() |
Conversion | .NET Framework (WF, WPF, ASP.NET and ASP.NET MVC) |
.NET Standard (UWP, .NET Core and Xamarin) |
---|---|---|
Converts Excel to PDF. | ![]() |
![]() |
Converts an entire Excel worksheet into a single image. | ![]() |
![]() |
Converts specific range of an Excel worksheet into a single image. | ![]() |
![]() |
Converts Excel chart to image. | ![]() |
![]() |
Converts Excel to HTML. | ![]() |
![]() |
Converts Excel document to ODS (Open Document Spreadsheet). | ![]() |
![]() |
NOTE
Worksheet to image conversion is supported from .NET Framework 2.0 and .NET Standard 1.4 onwards.
Supported Features in Blazor Platform
The list of supported and non-supported Excel features in Blazor platform is given below.
Features | Blazor Server-Side | Blazor Client-Side |
---|---|---|
Excel elements - text, image, table, auto filter, data sort, hyperlink, data validation, conditional formatting, formula, pivot table, comment, shape, chart, grouping, page setting and more. | ![]() |
![]() |
Presentation formatting - text, table, 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 DataTable, DataColumn, DataView, Array, Collection Objects and Nested Collection Objects to worksheet. | ![]() |
![]() |
Import data into a pre-formatted template using Template Markers. | ![]() |
![]() |
Export data from worksheet to datatable, nested class objects and nested collection objects. | ![]() |
![]() |
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 chart as image. | ![]() |
![]() |
Document Processing | Blazor Server-Side | Blazor Client-Side | ||
---|---|---|---|---|
Open | Save | Open | Save | |
Excel 97-2003 formats (*.XLS, *.XLT) | ![]() |
![]() |
![]() |
![]() |
Excel 2007 and above formats (*.XLSX, *.XLTX, *.XLSM) | ![]() |
![]() |
![]() |
![]() |
XML Spreadsheet 2003 (*.XML) | ![]() |
![]() |
![]() |
![]() |
CSV | ![]() |
![]() |
![]() |
![]() |
Excel to PDF | ![]() |
![]() |
![]() |
![]() |
Excel to HTML | ![]() |
![]() |
![]() |
![]() |
Worksheet to Image (PNG, JPEG) | ![]() |
![]() |
![]() |
![]() |