Sheet Class

File: wijmo.grid.sheet.js
Module: wijmo.grid.sheet

Represents a sheet within the FlexSheet control.

Constructor

constructor

constructor(owner?: FlexSheet, grid?: FlexGrid, sheetName?: string, rows?: number, cols?: number): Sheet

Initializes a new instance of the FlexSheet class.

Parameters

owner: FlexSheet Optional

The owner @see: FlexSheet control.
grid: FlexGrid Optional

The associated FlexGrid control used to store the sheet data. If not specified then the new FlexGrid control will be created.
sheetName: string Optional

The name of the sheet within the FlexSheet control.
rows: number Optional

The row count for the sheet.
cols: number Optional

The column count for the sheet.

Returns: Sheet

Properties

columnCount

Gets or sets the number of columns in the sheet.

Type: number

grid

Gets the associated FlexGrid control used to store the sheet data.

Type: FlexGrid

itemsSource

Gets or sets the array or ICollectionView for the FlexGrid instance of the sheet.

Type: any

name

Gets or sets the name of the sheet.

Type: string

rowCount

Gets or sets the number of rows in the sheet.

Type: number

selectionRanges

Gets the selection array.

Type: ObservableArray

visible

Gets or sets the sheet visibility.

Type: boolean

Methods

getCellStyle

getCellStyle(rowIndex: number, columnIndex: number): ICellStyle

Gets the style of specified cell.

Parameters

rowIndex: number

the row index of the specified cell.
columnIndex: number

the column index of the specified cell.

Returns: ICellStyle

onNameChanged

onNameChanged(e: EventArgs): void

Raises the nameChanged event.

Parameters

e: EventArgs

Returns: void

onVisibleChanged

onVisibleChanged(e: EventArgs): void

Raises the visibleChanged event.

Parameters

e: EventArgs

Returns: void

Events

nameChanged

Occurs after the sheet name has changed.

Arguments: EventArgs

visibleChanged

Occurs after the visible of sheet has changed.

Arguments: EventArgs