Overview
WorksheetCollection is a class in Aspose.Cells FOSS for Typescript.
Properties
| Name | Type | Access | Description |
|---|
worksheets | Worksheet[] | Read | |
length | number | Read | |
worksheetCount | number | Read | |
worksheet | Worksheet | Read | |
styles | Map<number, Style> | Read | |
Methods
| Signature | Description |
|---|
constructor(createDefault: boolean) | |
[Symbol.iterator]() → Iterator<Worksheet> | |
get(index: number) → Worksheet | undefined | |
getByName(name: string) → Worksheet | undefined | |
map(callback: (value: Worksheet, index: number) => T) → T[] | |
filter(callback: (value: Worksheet, index: number) => boolean) → Worksheet[] | |
forEach(callback: (value: Worksheet, index: number) => void) | |
find(callback: (value: Worksheet, index: number) => boolean) → Worksheet | undefined | |
indexOf(searchElement: Worksheet, fromIndex: number) → number | |
addWorksheet(name: string) → Worksheet | |
removeWorksheet(index: number) → boolean | |
moveWorksheet(fromIndex: number, toIndex: number) → boolean | |
getStyle(index: number) → Style | undefined | |
setStyle(index: number, style: Style) | |
clear() | |
getNumFmt(numFmtId: string | null) → string | |
See Also