WorkbookTable Class

File: wijmo.xlsx.js
Module: wijmo.xlsx
Implements: IWorkbookTable

Represents the WorkbookTable Object Model background setting definition.

Constructor

constructor

Properties

alterFirstColumn
alterLastColumn
columns
name
range
showBandedColumns
showBandedRows
showHeaderRow
showTotalRow
style

Constructor

constructor

constructor(): WorkbookTable

Initializes a new instance of the WorkbookTable class.

Returns: WorkbookTable

Properties

alterFirstColumn

Indicating whether the first column in the table should have the style applied.

Type: boolean

alterLastColumn

Indicating whether the last column in the table should have the style applied.

Type: boolean

columns

The columns of the table.

Type: WorkbookTableColumn[]

name

The name of the table. It is used to reference the table programmatically.

Type: string

range

The range on the relevant sheet that the table occupies expressed using A1 style referencing. i.e. "A1:D4". The reference shall include the totals row if it is shown.

Type: string

showBandedColumns

Indicating whether banded column formatting is applied.

Type: boolean

showBandedRows

Indicating whether banded row formatting is applied.

Type: boolean

showHeaderRow

Indicates whether show the header row for the table.

Type: boolean

showTotalRow

Indicates whether show the total row for the table.

Type: boolean

style

The table style to use with the table.

Type: WorkbookTableStyle