Edit

Share via

Excel.Interfaces.TableLoadOptions interface

  • Reference
Package:
excel

Represents an Excel table. To learn more about the table object model, read Work with tables using the Excel JavaScript API.

Remarks

[ API set: ExcelApi 1.1 ]

Properties

$all

Specifying $all for the load options loads all the scalar properties (such as Range.address) but not the navigational properties (such as Range.format.fill.color).
autoFilter

Represents the AutoFilter object of the table.
columns

Represents a collection of all the columns in the table.
highlightFirstColumn

Specifies if the first column contains special formatting.
highlightLastColumn

Specifies if the last column contains special formatting.
id

Returns a value that uniquely identifies the table in a given workbook. The value of the identifier remains the same even when the table is renamed.
legacyId

Returns a numeric ID.
name

Name of the table.

The set name of the table must follow the guidelines specified in the Rename an Excel table article.
rows

Represents a collection of all the rows in the table.
showBandedColumns

Specifies if the columns show banded formatting in which odd columns are highlighted differently from even ones, to make reading the table easier.
showBandedRows

Specifies if the rows show banded formatting in which odd rows are highlighted differently from even ones, to make reading the table easier.
showFilterButton

Specifies if the filter buttons are visible at the top of each column header. Setting this is only allowed if the table contains a header row.
showHeaders

Specifies if the header row is visible. This value can be set to show or remove the header row.
showTotals

Specifies if the total row is visible. This value can be set to show or remove the total row.
sort

Represents the sorting for the table.
style

Constant value that represents the table style. Possible values are: "TableStyleLight1" through "TableStyleLight21", "TableStyleMedium1" through "TableStyleMedium28", "TableStyleDark1" through "TableStyleDark11". A custom user-defined style present in the workbook can also be specified.
tableStyle

The style applied to the table.
worksheet

The worksheet containing the current table.

Property Details

$all

Specifying $all for the load options loads all the scalar properties (such as Range.address) but not the navigational properties (such as Range.format.fill.color).

$all?: boolean;

Property Value

boolean

autoFilter

Represents the AutoFilter object of the table.

autoFilter?: Excel.Interfaces.AutoFilterLoadOptions;

Property Value

Excel.Interfaces.AutoFilterLoadOptions

Remarks

[ API set: ExcelApi 1.9 ]

columns

Represents a collection of all the columns in the table.

columns?: Excel.Interfaces.TableColumnCollectionLoadOptions;

Property Value

Excel.Interfaces.TableColumnCollectionLoadOptions

Remarks

[ API set: ExcelApi 1.1 ]

highlightFirstColumn

Specifies if the first column contains special formatting.

highlightFirstColumn?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.3 ]

highlightLastColumn

Specifies if the last column contains special formatting.

highlightLastColumn?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.3 ]

id

Returns a value that uniquely identifies the table in a given workbook. The value of the identifier remains the same even when the table is renamed.

id?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.1 ]

legacyId

Returns a numeric ID.

legacyId?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.8 ]

name

Name of the table.

The set name of the table must follow the guidelines specified in the Rename an Excel table article.

name?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.1 ]

rows

Represents a collection of all the rows in the table.

rows?: Excel.Interfaces.TableRowCollectionLoadOptions;

Property Value

Excel.Interfaces.TableRowCollectionLoadOptions

Remarks

[ API set: ExcelApi 1.1 ]

showBandedColumns

Specifies if the columns show banded formatting in which odd columns are highlighted differently from even ones, to make reading the table easier.

showBandedColumns?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.3 ]

showBandedRows

Specifies if the rows show banded formatting in which odd rows are highlighted differently from even ones, to make reading the table easier.

showBandedRows?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.3 ]

showFilterButton

Specifies if the filter buttons are visible at the top of each column header. Setting this is only allowed if the table contains a header row.

showFilterButton?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.3 ]

showHeaders

Specifies if the header row is visible. This value can be set to show or remove the header row.

showHeaders?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.1 ]

showTotals

Specifies if the total row is visible. This value can be set to show or remove the total row.

showTotals?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.1 ]

sort

Represents the sorting for the table.

sort?: Excel.Interfaces.TableSortLoadOptions;

Property Value

Excel.Interfaces.TableSortLoadOptions

Remarks

[ API set: ExcelApi 1.2 ]

style

Constant value that represents the table style. Possible values are: "TableStyleLight1" through "TableStyleLight21", "TableStyleMedium1" through "TableStyleMedium28", "TableStyleDark1" through "TableStyleDark11". A custom user-defined style present in the workbook can also be specified.

style?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.1 ]

tableStyle

Note

This API is provided as a preview for developers and may change based on feedback that we receive. Do not use this API in a production environment.

The style applied to the table.

tableStyle?: Excel.Interfaces.TableStyleLoadOptions;

Property Value

Excel.Interfaces.TableStyleLoadOptions

Remarks

[ API set: ExcelApi BETA (PREVIEW ONLY) ]

worksheet

The worksheet containing the current table.

worksheet?: Excel.Interfaces.WorksheetLoadOptions;

Property Value

Excel.Interfaces.WorksheetLoadOptions

Remarks

[ API set: ExcelApi 1.2 ]