SheetSet
Contents
[
Hide
]SheetSet class
Describes a set of sheets.
class SheetSet;
Constructors
| Name | Description |
|---|---|
| constructor(number[]) | Creates a sheet set based on exact sheet indexes. |
| constructor(string[]) | Creates a sheet set based on exact sheet names. |
Methods
| Method | Description |
|---|---|
| isNull() | Checks whether the implementation object is null. |
| static getActive() | Gets a set with active sheet of the workbook. |
| static getVisible() | Gets a set with visible sheets of the workbook in their original order. |
| static getAll() | Gets a set with all sheets of the workbook in their original order. |
constructor(number[])
Creates a sheet set based on exact sheet indexes.
constructor(sheetIndexes: number[]);
Parameters:
| Parameter | Type | Description |
|---|---|---|
| sheetIndexes | number[] | zero based sheet indexes. |
Remarks
If a sheet is encountered that is not in the workbook, an exception will be thrown during rendering.
constructor(string[])
Creates a sheet set based on exact sheet names.
constructor(sheetNames: string[]);
Parameters:
| Parameter | Type | Description |
|---|---|---|
| sheetNames | string[] | sheet names. |
Remarks
If a sheet is encountered that is not in the workbook, an exception will be thrown during rendering.
isNull()
Checks whether the implementation object is null.
isNull() : boolean;
getActive()
Gets a set with active sheet of the workbook.
static getActive() : SheetSet;
Returns
getVisible()
Gets a set with visible sheets of the workbook in their original order.
static getVisible() : SheetSet;
Returns
getAll()
Gets a set with all sheets of the workbook in their original order.
static getAll() : SheetSet;
Returns