Get Started
Usage API

GetSheet

GetSheet(nameOrIndex) → { ApiWorksheet | null }

Returns an object that represents the sheet

Parameters:

Name Type Description
nameOrIndex string | number

Sheet name or Sheet index

Returns:

Type
ApiWorksheet | null

Example

Copy code
builder.CreateFile("xlsx");
oWorksheet = Api.GetSheet("Sheet1");
oWorksheet.GetRange("A1").SetValue("This is a sample text on 'Sheet1'.");
builder.SaveFile("xlsx", "GetSheet.xlsx");
builder.CloseFile();

Resulting document