Supported Features by Platforms
18 Jan 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. | |
|
| File formats | 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) | |
|
|
|