Get Started
Documentation

SetValue

SetValue(val)

Set the value for the current cell or a cell range.

Parameters:

Name Type Description
val string The general value for the cell or cell range in string format.

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