Spread.Sheets Documentation
setValue Method
The row index.
The column index.
The value to set for the specified cell.
The sheet area. If this parameter is not provided, it defaults to viewport.
Whether to ignore recalculation.
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 : nubmer,
   col : number,
   value : Object,
   sheetArea : SheetArea,
   ignoreRecalc : boolean
) : any;

Parameters

row
The row index.
col
The column index.
value
The value to set for the specified cell.
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

 

 


Copyright © GrapeCity, inc. All rights reserved.

Send comments on this topic.