Get Started
Documentation

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");
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