Essential XlsIO is a .NET class library that can read and write Microsoft Excel files. It includes a comprehensive API similar to the Microsoft Office Automation libraries. It does not have any external dependencies and can be used on systems that do not have Microsoft Excel installed.
Optimized for usage in a server environment where speed and low memory usage is critical. It works much faster and consumes lesser memory when compared to Office automation libraries.
There are no distribution fees, per-server licensing fees, or royalties, making XlsIO very cost-effective.
Very easy to migrate existing Office automation code to XlsIO since the APIs are very similar.
Read and write all popular Excel file formats including XLS and XLSX. You can even open a file in one format and save it back to another format.
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.
Design reports using Microsoft Excel and use XlsIO to dynamically populate it with data. You can then save the final report to an Excel file or export it to other supported formats like PDF.
Easily import data from all the common data sources like arrays, data tables and business objects into an Excel worksheet. Data in an existing worksheet can also be exported to the common data sources.
The built-in calculation engine can quickly evaluate formula cell values during runtime. It has support for over 180 Excel functions.
Excel templates are dynamically replaced with data when processed using XlsIO.
Create and manipulate all types of Excel charts with elements like chart title, legend, axis title, data labels, line styles, etc. These charts can also be converted to images using just a few lines of code.
Cell data validations can be applied with operators, alert messages, custom formulas and drop-down lists.
Visually highlight important values with data bars, icon sets and color scales based on conditions.
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, sub-totaling, etc.
Create and manipulate pivot tables and pivot charts in just a few lines of code. General filter options such as page filters, row filters and column filters with various pivot table visibility settings are supported.
Convert Excel document to PDF, HTML and images. Excel charts can also be converted to images.
Supports various formatting options like number formats, alignments, font settings, borders, colors, rich text, etc. that helps make data more readable.
Perform data sorting based on cell value, cell color and font color using multiple sorting algorithms.
Create custom styles or apply built-in styles to cell ranges. Built-in styles can also be applied for tables.
Supports various filter options like Top, Top10, Percent, etc. along with different filter data types.
Read and write password protected Excel documents. Enable and disable workbook and worksheet protections along with locking cells.
Create and manipulate autoshapes, comments, text boxes, combo boxes, check boxes and option buttons.
Enable page settings like orientation, paper size, scaling, margins, print area, print titles, header and footer, etc.
|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 the 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||XLS||XLSX|
|Import data from DataTable, DataColumn, DataView, Array and Business 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|
|Imports data from various external sources like Microsoft Access, SQL Server and Excel, which maintain the connection to refresh data dynamically|
|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|
|Creation and manipulation of Excel 2D charts|
|Creation and manipulation of Excel 3D charts|
|Creation and manipulation of custom charts|
|Creation and manipulation of Sparklines||NA|
|Creation and manipulation of pivot tables (While saving as XLS format, the pivot table is preserved as-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.|
|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|
|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|
|Creation and manipulation of data validation|
|Apply or modify auto-filters to filter worksheet data|
|Apply or modify data sorting|
|Find and replace data|
|Apply and modify view settings to freeze, unfreeze and split panes|
|Hide and unhide rows and columns|
|Merge and unmerge cells|
|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|
|Open and save encrypted and decrypted documents|
|Protect and unprotect workbook|
|Protect and unprotect worksheets|
|Lock and unlock cells for write protection|
|Set and get header and footer settings|
|Apply and modify horizontal and vertical page breaks|
|Apply and modify custom page breaks|
|Apply various page setup options like paper size, orientation, scaling, margins, etc.|
|Apply print settings|
|Creation and manipulation of auto shapes|
|Creation and manipulation of check boxes|
|Creation and manipulation of combo boxes|
|Creation and manipulation of comments|
|Creation and manipulation of text boxes|
|Converts Excel document to PDF|
|Converts an entire Excel worksheet into a single image|
|Converts specific range of an Excel worksheet into a single image|
|Converts Excel charts to images (.NET framework 4.0 and above)|