Optimized for a server environment where speed and low memory usage are critical. It works much faster and consumes less memory when compared to Office automation libraries.
Read and write files based on all popular Excel file format variants like XLS, XLSX, CSV, XLT, XLTX, XLTM, XLSM, and SpreadsheetML.
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.
Easily import data from all the common data sources, like arrays, and business objects, into an Excel worksheet. Data in an existing worksheet can also be exported to collection object.
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, and more.
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.
XlsIO 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, subtotaling, and more.
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.
XlsIO supports various formatting options like number formats, alignments, font settings, borders, colors, rich text, etc., that help 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.
XlsIO supports various filter options like Top, Top10, Percent, and others, along with different filter data types.
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, and more.
For more information about the supported features, please refer to this: documentation page.
Get our entire suite of file-format manipulation components for
$995 per user