Represents a data table for a range of cells.

WorksheetDataTable

new WorksheetDataTable(a: Worksheet, b: WorksheetRegion, c: WorksheetCell, d: WorksheetCell): WorksheetDataTable

Returns WorksheetDataTable

Gets or sets the region of cells in the data table.

get cellsInTable(): WorksheetRegion

Returns WorksheetRegion

set cellsInTable(a: WorksheetRegion): void

Parameters

Returns void

Gets or sets the cell used as the column-input cell in the data table.

get columnInputCell(): WorksheetCell

Returns WorksheetCell

set columnInputCell(a: WorksheetCell): void

Parameters

Returns void

Gets or sets the cell used as the row-input cell in the data table.

get rowInputCell(): WorksheetCell

Returns WorksheetCell

set rowInputCell(a: WorksheetCell): void

Parameters

Returns void

Gets the worksheet on which this data table resides.

get worksheet(): Worksheet

Returns Worksheet