SetValue
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