excesiv

This is a demo for Excesiv, a component that allows a web application to generate and read Excel files. Find out more about the project on GitHub.

Note: You will need Excel 2007+ installed on your computer.

A word of warning: This is a technical demo, so it doesn't perform anything actually useful. It's only meant to demonstrate the different functionalities of Excesiv.

Generating an Excel workbook

Excesiv allows an application to populate a workbook off of a template (a workbook with column headers and formatting set up, but empty of data).

In the example below, the user gives an upper bound parameter and a number of rows. The application will then create random numbers using the upper bound and populate an Excel template with the requested number of rows and some header data. Go ahead, try it!

Number of rows (between 1 and 100) Upper bound parameter (between 1 and 100)

Generate

Reading an Excel workbook

Excesiv also allows an application to parse and read an Excel workbook. The workbook needs to be set up properly for Excesiv to know what to do with it. Usually it will be a workbook generated by Excesiv, downloaded and modified by the user, then uploaded back to Excesiv.

Use the workbook downloaded from the example above (using any other workbook won't work, trust me). Modify it, if you want, changing any numbers under a red header (the workbook is set up so Excesiv will read those cells). Save it, then upload it back here. Excesiv will read the cells and perform some basic statistics. It will also read the cells with different data types under the purple headers to show they are supported.

Or drop file here

That's it!

Thanks for trying out Excesiv! If you want to learn more how it works, or how to use it in your own applications, be sure to visit the project's page on GitHub.