Overview

Essential XlsIO can be used to generate a new XLS document from scratch, extract data from a spreadsheet or even edit an existing spreadsheet.

Essential XlsIO supports the creation of richly formatted spreadsheets. Advanced features like Data Validation, Conditional Formatting and Charts can also be applied to spreadsheet-cells in a spreadsheet created using Essential XlsIO.

You can open an existing spreadsheet and edit or insert content into it. This lets you create XLS document templates using MS Excel with rich cell-formats. You can then open such templates using XlsIO and insert content dynamically during run-time and distribute the newly created XLS document to your end-users.The data flow of the edit spreadsheet process is illustrated below:

There are some features like VBA Macros which cannot be created using XlsIO's API. These features can be made available in a template created using MS Excel. XlsIO will preserve this information while editing and saving these templates.

Essential XlsIO also provides APIs to let you read the contents of an existing XLS document. You can create applications that simply consume data available in an XLS document.

Essential XlsIO lets you read the content and format settings of the cells.

You can also read and write content into the same document.