SetValue

SetValue(data) → { boolean }

Sets a value to the current cell or cell range.

Parameters:

Name Type Description
data string | bool | number | Array.<Array> | Array.<Array.<Array>>

The general value for the cell or cell range.

Returns:

Type
boolean

Example

Copy code
builder.CreateFile("xlsx");
var oWorksheet = Api.GetActiveSheet();
oWorksheet.GetRange("B1").SetValue("2");
oWorksheet.GetRange("B2").SetValue("2");
oWorksheet.GetRange("A3").SetValue("2x2=");
oWorksheet.GetRange("B3").SetValue("=B1*B2");
builder.SaveFile("xlsx", "SetValue.xlsx");
builder.CloseFile();

Resulting document