Easy opening of an existing spreadsheet and editing it or inserting content into it is possible with Essential XlsIO. This enables the creation of XLS or XLSX document templates using MS Excel with rich cell-formats. Such templates can be opened using Essential XlsIO and contents can be inserted into these documents dynamically during runtime. The newly created documents can be distributed to end-users.

The following image illustrates the data flow of this process.

Overview

Essential XlsIO can be used to generate a new Excel document of .XLS, .XML[Spreadsheetml], .XLSX [Excel 2007, Excel 2010] and .CSV format, extract data from an existing spreadsheet document or even edit an existing spreadsheet.

• Spreadsheet Generation
• Edit Spreadsheet
• Extract Data From Spreadsheet