WorksheetCollection

WorksheetCollection

Overview

WorksheetCollection is a class in Aspose.Cells FOSS for Typescript.

Properties

NameTypeAccessDescription
worksheetsWorksheet[]Read
lengthnumberRead
worksheetCountnumberRead
worksheetWorksheetRead
stylesMap<number, Style>Read

Methods

SignatureDescription
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