Worksheet

Overview

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

Name	Type	Access
`cell`	`: string`	Read
`link`	`: Hyperlink`	Read
`startRow`	`: number`	Read
`startCol`	`: number`	Read
`endRow`	`: number`	Read
`endCol`	`: number`	Read
`range`	`: string`	Read
`rules`	`: ConditionalFormatRule[]`	Read
`name`	`string`	Read/Write
`index`	`number`	Read
`cells`	``	Read
`value`	`CellValue \| undefined`	Read/Write
`dataValidations`	``	Read
`comments`	``	Read
`hyperlinks`	``	Read
`autoFilter`	``	Read
`conditionalFormats`	``	Read
`mergedCells`	``	Read
`defaultColumnWidth`	`number \| undefined`	Read/Write
`defaultRowHeight`	`number \| undefined`	Read/Write
`shapes`	`ShapeInfo[]`	Read
`charts`	`ChartCollection`	Read
`images`	`ImageInfo[]`	Read

Signature	Description
`constructor(name: string, index: number)`
`getCell(row: number, col: number)` → `Cell \| undefined`
`getCellByRef(ref: string)` → `Cell \| undefined`
`getCell2(key: string)` → `Cell`
`putValue(key: string, value: CellValue)` → `Cell`
`addDataValidation(validation: DataValidation, range: string)`
`addComment(comment: Comment)`
`addHyperlink(cellRef: string, hyperlink: Hyperlink)`
`setAutoFilter(range: string)`
`removeAutoFilter()`
`addConditionalFormat(range: string, rules: ConditionalFormatRule[])`
`mergeCells(range: string)`
`unmergeCells(range: string)`
`setColumnWidth(column: number, width: number)`
`getColumnWidth(column: number)` → `number \| undefined`
`setRowHeight(row: number, height: number)`
`getRowHeight(row: number)` → `number \| undefined`
`setRowHidden(row: number, hidden: boolean)`
`isRowHidden(row: number)` → `boolean`
`setCellStyle(cellRef: string, style: any)`
`addShape(shape: ShapeInfo)`
`addImage(image: ImageInfo)`
`toXml(drawingIndex: number)` → `string`
`getXml(drawingIndex: number)` → `string`