Excel.Interfaces.TableData interface

Specifies the alternative text for accessibility.

altTextDescription?: string;

Property Value

Remarks

[ API set: ExcelApi BETA (PREVIEW ONLY) ]

Specifies a summary for the table, such as one used by screen readers.

altTextTitle?: string;

Property Value

Remarks

[ API set: ExcelApi BETA (PREVIEW ONLY) ]

Represents the AutoFilter object of the table.

autoFilter?: Excel.Interfaces.AutoFilterData;

Property Value

Remarks

[ API set: ExcelApi 1.9 ]

Represents a collection of all the columns in the table.

columns?: Excel.Interfaces.TableColumnData[];

Property Value

Remarks

[ API set: ExcelApi 1.1 ]

Specifies a comment associated with the table.

comment?: string;

Property Value

Remarks

[ API set: ExcelApi BETA (PREVIEW ONLY) ]

Specifies if the first column contains special formatting.

highlightFirstColumn?: boolean;

Property Value

Remarks

[ API set: ExcelApi 1.3 ]

Specifies if the last column contains special formatting.

highlightLastColumn?: boolean;

Property Value

Remarks

[ API set: ExcelApi 1.3 ]

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?: string;

Property Value

Remarks

[ API set: ExcelApi 1.1 ]

Retrieves whether the table is currently active.

isActive?: boolean;

Property Value

Remarks

[ API set: ExcelApi BETA (PREVIEW ONLY) ]

Returns a numeric ID.

legacyId?: string;

Property Value

Remarks

[ API set: ExcelApi 1.8 ]

Name of the table.

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

name?: string;

Property Value

Remarks

[ API set: ExcelApi 1.1 ]

Represents a collection of all the rows in the table.

rows?: Excel.Interfaces.TableRowData[];

Property Value

Remarks

[ API set: ExcelApi 1.1 ]

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

Remarks

[ API set: ExcelApi 1.3 ]

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

Remarks

[ API set: ExcelApi 1.3 ]

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

Remarks

[ API set: ExcelApi 1.3 ]

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

showHeaders?: boolean;

Property Value

Remarks

[ API set: ExcelApi 1.1 ]

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

showTotals?: boolean;

Property Value

Remarks

[ API set: ExcelApi 1.1 ]

Represents the sorting for the table.

sort?: Excel.Interfaces.TableSortData;

Property Value

Remarks

[ API set: ExcelApi 1.2 ]

Retrieves the data source type from which the table originates.

source?: Excel.TableSource | "External" | "Range" | "Xml" | "Query" | "Model";

Property Value

Remarks

[ API set: ExcelApi BETA (PREVIEW ONLY) ]

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?: string;

Property Value

Remarks

[ API set: ExcelApi 1.1 ]

The style applied to the table.

tableStyle?: Excel.Interfaces.TableStyleData;

Property Value

Remarks

[ API set: ExcelApi BETA (PREVIEW ONLY) ]