Supported Features by Platforms

29 Nov 202415 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. Yes Yes
Open an existing Excel workbook from file system or stream. Yes Yes
Save Excel workbook to a local file, stream, or stream it to a client browser. Yes Yes
Read worksheets on demand when 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 .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. Yes Yes
Import data from collection objects to worksheet. Yes Yes
Import data from nested collection objects to worksheet. Yes Yes
Import data into a pre-formatted template using Template Markers. Yes Yes
Importing large amounts of data with minimal memory consumption can be achieved using the import on save option. Yes Yes
Export data from worksheet to datatable and collection objects. Yes Yes
Export data from worksheet to nested class. Yes Yes
Imports data from various external sources like Microsoft Access, SQL Server and Excel, which maintain the connection to refresh data dynamically. Yes No
Formulas .NET Framework
(WF, WPF, ASP.NET and ASP.NET MVC)
.NET Standard
(UWP, .NET Core and Xamarin)
Read and write Excel formulas. Yes Yes
Add or modify named ranges in workbook and worksheet levels. Yes Yes
Performs 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
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. Yes Yes
Creation and manipulation of Excel 3-D charts. Yes Yes
Creation and manipulation of custom charts. Yes Yes
Creation and manipulation of sparklines. Yes Yes
Creation and manipulation of Excel 2016 charts. Yes Yes
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). Yes Yes
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 Yes
Supports pivot table settings such as visibility of field list, collapse button, field caption and field option, header captions, etc. Yes Yes
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. Yes Yes
Protect and unprotect workbook. Yes Yes
Protect and unprotect worksheets. Yes Yes
Lock and unlock cells for write protection. Yes Yes
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). 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 data sorting. Yes Yes
Find and replace data. Yes Yes
Row/Column Manipulation
Apply or modify view settings to freeze, unfreeze, and split panes. Yes Yes
Hide or unhide rows and columns. Yes Yes
Merge and unmerge cells. Yes Yes
Auto-Fit Rows and Columns. Yes Yes
Insert
Insertion and deletion of images in worksheets. Yes Yes
Apply or modify 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
Addition and deletion of OLE objects. Yes Yes
Page Setup
Get or set header and footer settings. Yes Yes
Apply or modify horizontal and vertical page breaks. Yes Yes
Apply or modify custom page breaks. Yes Yes
Apply various page setup options like paper size, orientation, scaling, margins, etc. Yes Yes
Apply print 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
Miscellaneous
Preserve Macros Yes Yes
Conversion .NET Framework
(WF, WPF, ASP.NET and ASP.NET MVC)
.NET Standard
(UWP, .NET Core and Xamarin)
Converts Excel to PDF. Yes Yes
Converts an entire Excel worksheet into a single image. Yes Yes
Converts specific range of an Excel worksheet into a single image. Yes Yes
Converts Excel chart to image. Yes Yes
Converts Excel to HTML. Yes Yes
Converts Excel document to ODS (Open Document Spreadsheet). Yes No

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. Yes Yes
Presentation formatting - text, table, 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 and Nested Collection Objects to worksheet. Yes Yes
Import data into a pre-formatted template using Template Markers. Yes Yes
Export data from worksheet to datatable, nested class objects and nested 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 chart as image. Yes Yes
Document Processing Blazor Server-Side Blazor Client-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 Yes Yes Yes Yes
Excel to HTML Yes Yes Yes Yes
Worksheet to Image (PNG, JPEG) Yes Yes Yes Yes