Excel |
The ExcelTable type exposes the following members.
| Name | Description | |
|---|---|---|
| Columns | Gets the columns of the table. | |
| DataRange | Gets the data rows of the table, without the header row and the totals row. | |
| Name | Gets or sets the name of the table. The name is used in formulas with structured references, for example =SUM(Sales[Amount]). It must start with a letter or an underscore, cannot contain spaces and must be unique in the workbook. | |
| Range | Gets the range of the table, including the header row and the totals row. | |
| ShowBandedColumns | Gets or sets a value indicating if the columns of the table are banded (alternate column colors of the table style). The default value is false. | |
| ShowBandedRows | Gets or sets a value indicating if the rows of the table are banded (alternate row colors of the table style). The default value is true. | |
| ShowFilterButtons | Gets or sets a value indicating if the header row shows the filter buttons. The default value is true. | |
| ShowFirstColumn | Gets or sets a value indicating if the first column has the special formatting of the table style. The default value is false. | |
| ShowLastColumn | Gets or sets a value indicating if the last column has the special formatting of the table style. The default value is false. | |
| ShowTotalsRow | Gets or sets a value indicating if the table has a totals row below the data. Showing the totals row adds a row to the table and moves the cells below the table, in its columns, one row down. Set the calculation of each column with TotalsCalculation. The default value is false. | |
| Style | Gets or sets the built-in style of the table. The default style of a new table is Medium2. | |
| Worksheet | Gets the worksheet of this table. |