New to Kendo UI for Angular? Start a free 30-day trial

SheetDescriptor

Represents the interface of a Spreadsheet document sheet and its content.

NameTypeDefaultDescription

activeCell?

string

The active cell in the sheet, for example, A1.

columns?

SheetColumn[]

An array which defines the columns in this sheet and their content.

defaultCellStyle?

CellDefaultStyle

The default cell styles that will be applied to the sheet cells.

drawings?

{ height: number; image: string; offsetX: number; offsetY: number; opacity: any; topLeftCell: any; width: number; }[]

An array which contains the drawings used in this sheet.

frozenColumns?

number

The number of frozen columns in this sheet.

frozenRows?

number

The number of frozen rows in this sheet.

{ ref: string; target: string; }[]

An array which contains the hyperlinks of the cells.

mergedCells?

string[]

An array of merged cell ranges, for example, B1:D2.

name?

string

The name of the sheet.

rows?

SheetRow[]

The row data for this sheet.

selection?

string

The selected range in the sheet, for example, A1:B10.

showGridLines?

boolean

true

A Boolean value which indicates if the grid lines of the sheet will be displayed.

state?

"visible" | "hidden" | "veryHidden"

'visible'

The state of the sheet.