[]
        
(Showing Draft Content)

WorkbookTable Class

WorkbookTable Class

Represents the WorkbookTable Object Model background setting definition.

Heirarchy

  • WorkbookTable

Constructors

constructor

Properties

alterFirstColumn

alterFirstColumn: boolean

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

alterLastColumn

alterLastColumn: boolean

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

columns

The columns of the table.

name

name: string

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

range

range: string

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.

showBandedColumns

showBandedColumns: boolean

Indicating whether banded column formatting is applied.

showBandedRows

showBandedRows: boolean

Indicating whether banded row formatting is applied.

showHeaderRow

showHeaderRow: boolean

Indicates whether show the header row for the table.

showTotalRow

showTotalRow: boolean

Indicates whether show the total row for the table.

style

The table style to use with the table.