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	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.

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.