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