Overview
XlsIO can be used to generate a new XLS document from scratch, extract data from an existing spreadsheet document or even edit an existing spreadsheet.
Excel 2007 Support
Essential XlsIO is one of the first products to natively support Excel 2007 Xlsx file format. 100% support for all Excel object types is not yet available, but several commonly used elements are already supported.
Formatting
Numerous formatting options are available for customising the look and feel of the cells in the worksheet.
Calculations
Essential XlsIO has advanced support for working with Formulas in cells.
Data Manipulation
Essential XlsIO has advanced support for working with Data in a worksheet. Here are some key functionalities that enables working with data easier.
Worksheet Manipulation
Essential XlsIO has advanced support for manipulating the worksheet.
Comments
Essential XlsIO has APIs for reading and writing comments for cells in a worksheet.
Charts
Essential XlsIO has advanced support for creating and modifying Excel charts inside a workbook. There is an option to choose between creating a chart as an embedded chart or as a worksheet chart.
Security
Essential XlsIO has support for securing the content, structure and windows of a Excel workbook and worksheet.
Document Settings
Essential XlsIO can work with spreadsheets that are stored as streams and can also save to a stream.
Spreadsheet Property Settings
Essential XlsIO has support for reading and writing the spreadsheet properties.
Performance
Essential XlsIO is known for its high performance for generating Excel files with large number of rows and columns. It has superior performance over MS Excel in the context of report generation processes.
Syncfusion licenses on a simple per-developer basis and charges no royalties, runtimes, or server deployment fees. A license is needed for each developer who will be working with the products, and volume discounts are available.
All products include a one-year subscription for unlimited technical support and access to new releases