GetSheet
Returns an object that represents a sheet.
Parameters:
| Name |
Type |
Description |
| nameOrIndex |
string | number
|
Sheet name or sheet index. |
Returns:
- Type
-
ApiWorksheet | null
Example
Copy code
builder.CreateFile("xlsx");
var oWorksheet = Api.GetSheet("Sheet1");
oWorksheet.GetRange("A1").SetValue("This is a sample text on 'Sheet1'.");
builder.SaveFile("xlsx", "GetSheet.xlsx");
builder.CloseFile();
Resulting document