ExcelTable Properties
From Office Open XML
The ExcelTable type exposes the following members.
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
|
