Exporting to Spreadsheet and Excel

Using ES2Spreadsheet, Easy Save has the ability to create spreadsheets and store them in the CSV format which is supported by all popular spreadsheet software included Excel, OSX Numbers and OpenOffice.

To create a spreadsheet, you do the following:

  1. Create an ES2Spreadsheet object.
  2. Use SetCell to set the value of a cell.
    • Note that columns and row numbers start at 0.
    • If the value isn’t a string, it will use ToString() on the value to get a string representation of it.
  3. Use Save to store the spreadsheet to a file.

C#

JS

If you want to append data to an existing spreadsheet, set the spreadsheet’s append variable to true. Any rows in the spreadsheet will be added to the end of the one we’re saving to.

Currently ES2Spreadsheet is unable to do the following, but may have these implemented in the future:

  • Save formulas.
  • Store formatting or styling information.
  • Save multiple worksheets.