SetValue
function SetValue(data: string | bool | number | [][] | [][][] = null): booleanDescription
Sets a value to the current cell or cell range.
Parameters
- data
string | bool | number | [][] | [][][]default: null The general value for the cell or cell range.
Returns
booleanTry It
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");