ES2Spreadsheet.SetCell

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

Parameters

[table th=”0″]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.”[/table]

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

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