The ExcelTable type exposes the following members.
Methods
Name | Description | |
---|---|---|
Equals | (Inherited from Object.) | |
GetHashCode |
Serves as a hash function for a particular type.
(Inherited from Object.) | |
GetType |
Gets the Type of the current instance.
(Inherited from Object.) | |
ToString | (Inherited from Object.) |
Properties
Name | Description | |
---|---|---|
Address |
The address of the table
| |
Columns |
Collection of the columns in the table
| |
DataCellStyleName |
Named style used for the data cells
| |
HeaderRowCellStyle |
Named style used for the header row
| |
Name |
The name of the table object in Excel
| |
ShowColumnStripes |
Display banded columns
| |
ShowFilter |
If the header row has an autofilter
| |
ShowFirstColumn |
Display special formatting for the first row
| |
ShowHeader |
If the header row is visible or not
| |
ShowLastColumn |
Display special formatting for the last row
| |
ShowRowStripes |
Display banded rows
| |
ShowTotal |
If the total row is visible or not
| |
StyleName |
The style name for custum styles
| |
TableStyle |
The table style. If this property is cusom, the style from the StyleName propery is used.
| |
TableUri |
The package internal URI to the Table Xml Document.
| |
TableXml |
Provides access to the XML data representing the table in the package.
| |
TotalsRowCellStyle |
Named style used for the total row
| |
WorkSheet |
The worksheet of the table
|