WorksheetCollection
Overview
WorksheetCollection is a class in Aspose.Cells FOSS for TypeScript.
This class declares 16 methods for WorksheetCollection objects in TypeScript programs.
Available methods include: [Symbol.iterator], addWorksheet, clear, constructor, filter, find, forEach, get, getByName, getNumFmt, getStyle, indexOf, and 4 additional methods.
Public members are accessible to any TypeScript application after installing the Aspose.Cells FOSS for TypeScript package.
Properties: length, styles, worksheet, worksheetCount, worksheets.
Properties
| Name | Type | Access | Description |
|---|---|---|---|
worksheets | Worksheet[] | Read | Gets the worksheets. |
length | number | Read | Gets the length. |
worksheetCount | number | Read | Gets the worksheet count. |
worksheet | Worksheet | Read | Gets the worksheet. |
styles | Map<number, Style> | Read | Gets the styles. |
Methods
| Signature | Description |
|---|---|
constructor(createDefault: boolean) | Calls constructor(createDefault) on this WorksheetCollection instance. |
[Symbol.iterator]() → Iterator<Worksheet> | Calls [Symbol.iterator] on this WorksheetCollection instance. |
get(index: number) → Worksheet | undefined | Calls get(index) on this WorksheetCollection instance. |
getByName(name: string) → Worksheet | undefined | Calls getByName(name) on this WorksheetCollection instance. |
map(callback: (value: Worksheet, index: number) => T) → T[] | Calls map(callback) on this WorksheetCollection instance. |
filter(callback: (value: Worksheet, index: number) => boolean) → Worksheet[] | Calls filter(callback) on this WorksheetCollection instance. |
forEach(callback: (value: Worksheet, index: number) => void) | Calls forEach(callback) on this WorksheetCollection instance. |
find(callback: (value: Worksheet, index: number) => boolean) → Worksheet | undefined | Calls find(callback) on this WorksheetCollection instance. |
indexOf(searchElement: Worksheet, fromIndex: number) → number | Calls indexOf(searchElement, fromIndex) on this WorksheetCollection instance. |
addWorksheet(name: string) → Worksheet | Calls addWorksheet(name) on this WorksheetCollection instance. |
removeWorksheet(index: number) → boolean | Calls removeWorksheet(index) on this WorksheetCollection instance. |
moveWorksheet(fromIndex: number, toIndex: number) → boolean | Calls moveWorksheet(fromIndex, toIndex) on this WorksheetCollection instance. |
getStyle(index: number) → Style | undefined | Calls getStyle(index) on this WorksheetCollection instance. |
setStyle(index: number, style: Style) | Sets the style value. |
clear() | Calls clear on this WorksheetCollection instance. |
getNumFmt(numFmtId: string | null) → string | Calls getNumFmt(numFmtId) on this WorksheetCollection instance. |
