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