Skip to main content
Row

Table Properties

A table in a worksheet.
Name Description
AutoFilter Provides access to an object that contains options to filter data in a table.
Columns Provides access to the collection of table columns.
Comment Gets or sets a string that provides additional information about the table.
DataRange Returns the cell range that contains table data.
HeaderRowRange Returns the cell range that contains the header row of the table.
Name Gets or sets the table name.
Range Specifies the cell range that contains the entire table.
Rows Provides access to the collection of table rows.
ShowHeaders Gets or sets whether the table header row is visible.
ShowTableStyleColumnStripes Indicates whether alternate shading should be applied to the table columns.
ShowTableStyleFirstColumn Indicates whether special formatting should be applied to the first column of the table.
ShowTableStyleLastColumn Indicates whether special formatting should be applied to the last column of the table.
ShowTableStyleRowStripes Indicates whether alternate shading should be applied to the table rows.
ShowTotals Specifies whether the table total row is visible.
Style Gets or sets the style applied to the table.
TotalRowRange Returns the cell range that contains the total row of the table.
See Also