Sets the cell offset.
Name | Type | Description |
nRow | number | The row number. |
nCol | number | The column number. |
builder.CreateFile("xlsx"); var oWorksheet = Api.GetActiveSheet(); oWorksheet.GetRange("B3").SetValue("Old Range"); var oRange = oWorksheet.GetRange("B3"); oRange.SetOffset(2, 2); oRange.SetValue("New Range"); builder.SaveFile("xlsx", "SetOffset.xlsx"); builder.CloseFile();