General Information
.NET Subscription
Desktop
Web
Controls and Extensions
Mainteinance Mode
Enterprise and Analytic Tools
Quality Assurance and Productivity
Frameworks and Libraries
General Information
.NET Subscription
Desktop
Web
Controls and Extensions
Mainteinance Mode
Enterprise and Analytic Tools
Quality Assurance and Productivity
Frameworks and Libraries
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. |