GetRange
Returns an object that represents the selected range of the current sheet. Can be a single cell - A1, or cells
from a single row - A1:E1, or cells from a single column - A1:A10, or cells from several rows and columns - A1:E10.
Parameters:
Name |
Type |
Description |
Range1 |
string | ApiRange
|
The range of cells from the current sheet. |
Range2 |
string | ApiRange
|
The range of cells from the current sheet. |
Returns:
- Type
-
ApiRange | null
Example
Copy code
builder.CreateFile("xlsx");
var oWorksheet = Api.GetActiveSheet();
oWorksheet.GetRange("A2").SetValue("2");
var oRange = oWorksheet.GetRange("A1:D5");
oRange.SetAlignHorizontal("center");
builder.SaveFile("xlsx", "GetRange.xlsx");
builder.CloseFile();
Resulting document