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