Table Members
A table in a worksheet.Properties
| 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 | Gets the cell range that contains table data. |
| HeaderRowRange | Gets the cell range that contains the header row of the table. |
| Name | Gets or sets the table name. |
| Range | Gets or sets the range of cells that contains the 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 | Gets or sets whether the table total row is visible. |
| Style | Gets or sets the style applied to the table. |
| TotalRowRange | Gets the cell range that contains the total row of the table. |
Methods
| Name | Description |
|---|---|
| ConvertToRange() | Converts the table to a regular range of cells without losing data and formatting. |
| Delete() | Removes the table from the worksheet. |
| GetDataSource() | Creates the data source from the worksheet table using the specified options. |
| GetDataSource(RangeDataSourceOptions) | Creates the data source from the worksheet table using the specified options. |
See Also
Feedback