Excel.Interfaces.TableCollectionLoadOptions interface

Represents a collection of all the tables that are part of the workbook or worksheet, depending on how it was reached.

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).

columns

For EACH ITEM in the collection: Represents a collection of all the columns in the table.

id

For EACH ITEM in the collection: 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.

name

For EACH ITEM in the collection: Name of the table.

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

rows

For EACH ITEM in the collection: Represents a collection of all the rows in the table.

showHeaders

For EACH ITEM in the collection: Specifies if the header row is visible. This value can be set to show or remove the header row.

showTotals

For EACH ITEM in the collection: Specifies if the total row is visible. This value can be set to show or remove the total row.

style

For EACH ITEM in the collection: 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.

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

columns

For EACH ITEM in the collection: Represents a collection of all the columns in the table.

columns?: Excel.Interfaces.TableColumnCollectionLoadOptions;

Property Value

Remarks

[ API set: ExcelApi 1.1 ]

id

For EACH ITEM in the collection: 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 ]

name

For EACH ITEM in the collection: 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

For EACH ITEM in the collection: Represents a collection of all the rows in the table.

rows?: Excel.Interfaces.TableRowCollectionLoadOptions;

Property Value

Remarks

[ API set: ExcelApi 1.1 ]

showHeaders

For EACH ITEM in the collection: 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

For EACH ITEM in the collection: 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 ]

style

For EACH ITEM in the collection: 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 ]