Supported Features by Platforms

8 Dec 202315 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)