GetSheet

GetSheet(nameOrIndex) → { ApiWorksheet | null }

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