Sets a value to the current cell or cell range.
Name | Type | Description |
data | string | bool | number | Array.<Array> | Array.<Array.<Array>> | The general value for the cell or cell range. |
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();