setValue Method

Sets the value for the specified cell in the specified sheet area.

Syntax

Javascript (Usage)
Javascript (Specification)

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,
   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.

Javascript

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

Reference

Worksheet type