ES2Spreadsheet.SetCell

public void SetCell(int col, int row, object value)

Parameters

col	The column of the cell we want to set.
row	The row of the cell we want to set.
value	The value we want to set the cell to, using ToString() to get the value as a string.

Description

Sets a cell at the given location to this value. If the value is not a string, it will use ToString() to get the string representation of the value.

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");

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");

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");