Edit Spreadsheet

You can also easily 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 but without any meaningful data in the cells. You can then open such templates using XlsIO and insert content into these documents dynamically during runtime at the right location and distribute the newly created Xls documents to your end-users.

The below image illustrates the data flow of this process.

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