ES2Spreadsheet

Constructors

public ES2Spreadsheet()

Properties

[table th=”0″ ]bool,append,”Whether to append this spreadsheet to previously-saved sheets when saving.”

[/table]

Methods

[table th=”0″]SetCell,”Sets a cell at a given column and row to contain this value.”

Save,”Stores the spreadsheet to a file.”

[/table]

Description

The ES2Spreadsheet class allows you to create a spreadsheet which can be stored and opened with spreadsheet software such as Excel, OSX Numbers or OpenOffice.

C#

ES2Spreadsheet sheet = new ES2Spreadsheet();
// Add data to cells in the spreadsheet.
for(int col=0; col<10; col++)
    for(int row=0; row<8; row++)
        sheet.SetCell(col, row, "someData");
sheet.Save("mySheet.csv");

JS

var sheet : ES2Spreadsheet = new ES2Spreadsheet();
// Add data to cells in the spreadsheet.
for(var col=0; col<10; col++)
    for(var row=0; row<8; row++)
        sheet.SetCell(col, row, "someData");
sheet.Save("mySheet.csv");