SpreadJS 13
GC.Spread.Sheets Namespace / Worksheet type / setValue Method
The row index.
The column index.
The value to set for the specified cell. if the value is rich text format, should include a richText field which type is a rich text style array.
The sheet area. If this parameter is not provided, it defaults to viewport.
Whether to ignore recalculation.
In This Topic
    setValue Method
    In This Topic
    Sets the value for the specified cell in the specified sheet area.
    Syntax
    var instance = new GC.Spread.Sheets.Worksheet(name);
    var returnValue; // Type: any
    returnValue = instance.setValue(row, col, value, sheetArea, ignoreRecalc);
    function setValue( 
       row : number,
       col : number,
       value : Object,
       (optional) sheetArea : SheetArea,
       ignoreRecalc : boolean
    ) : any;

    Parameters

    row
    The row index.
    col
    The column index.
    value
    The value to set for the specified cell. if the value is rich text format, should include a richText field which type is a rich text style array.
    sheetArea
    The sheet area. If this parameter is not provided, it defaults to viewport.
    ignoreRecalc
    Whether to ignore recalculation.
    Example
    This example uses the setValue method.
    sheet.setValue(0,2,"ColumnHeader", GC.Spread.Sheets.SheetArea.colHeader);
    sheet.setValue(2,0,"RowHeader", GC.Spread.Sheets.SheetArea.rowHeader);
    sheet.setValue(2,0,"viewport", GC.Spread.Sheets.SheetArea.viewport);
    See Also

    Reference

    Worksheet type