Table Properties
A table in a worksheet.Name | Description |
---|---|
Auto |
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. |
Data |
Returns the cell range that contains table data. |
Header |
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. |
Show |
Gets or sets whether the table header row is visible. |
Show |
Indicates whether alternate shading should be applied to the table columns. |
Show |
Indicates whether special formatting should be applied to the first column of the table. |
Show |
Indicates whether special formatting should be applied to the last column of the table. |
Show |
Indicates whether alternate shading should be applied to the table rows. |
Show |
Specifies whether the table total row is visible. |
Style | Gets or sets the style applied to the table. |
Total |
Returns the cell range that contains the total row of the table. |
See Also