| Name | Description | Type | Additional information |
|---|---|---|---|
| CacheIndex | integer |
None. |
|
| DisplayErrorString | boolean |
None. |
|
| DisplayNullString | boolean |
None. |
|
| IsColumnGrand | boolean |
None. |
|
| EnableDrilldown | boolean |
None. |
|
| EnableFieldDialog | boolean |
None. |
|
| EnableWizard | boolean |
None. |
|
| ErrorString | string |
None. |
|
| ManualUpdate | boolean |
None. |
|
| MergeLabels | boolean |
None. |
|
| Name | string |
None. |
|
| NullString | string |
None. |
|
| PageFieldOrder | PagesOrderType |
None. |
|
| PageFieldStyle | string |
None. |
|
| PageFieldWrapCount | integer |
None. |
|
| IsRowGrand | boolean |
None. |
|
| Cache | XlsPivotCache |
None. |
|
| Location | Collection of Object |
None. |
|
| PivotConditionalFormats | Collection of Object |
None. |
|
| PivotFields | Collection of Object |
None. |
|
| DataFields | Collection of Object |
None. |
|
| Workbook | XlsWorkbook |
None. |
|
| Worksheet | XlsWorksheet |
None. |
|
| ShowDrillIndicators | boolean |
None. |
|
| DisplayFieldCaptions | boolean |
None. |
|
| RepeatItemsOnEachPrintedPage | boolean |
None. |
|
| BuiltInStyle | PivotBuiltInStyles |
None. |
|
| ShowRowGrand | boolean |
None. |
|
| ShowColumnGrand | boolean |
None. |
|
| Options | IPivotTableOptions |
None. |
|
| FirstDataCol | integer |
None. |
|
| FirstDataRow | integer |
None. |
|
| FirstHeaderRow | integer |
None. |
|
| ColumnsPerPage | integer |
None. |
|
| RowsPerPage | integer |
None. |
|
| ShowColHeaderStyle | boolean |
None. |
|
| ShowColStripes | boolean |
None. |
|
| ShowLastCol | boolean |
None. |
|
| ShowRowHeaderStyle | boolean |
None. |
|
| ShowRowStripes | boolean |
None. |
|
| ShowDataFieldInRow | boolean |
None. |
|
| CalculatedFields | IPivotCalculatedFields |
None. |
|
| PageFields | Collection of Object |
None. |
|
| RowFields | Collection of Object |
None. |
|
| ColumnFields | Collection of Object |
None. |
|
| IsChanged | boolean |
None. |
|
| ReportFilters | Collection of PivotReportFilter |
None. |
|
| AllSubTotalTop | boolean |
None. |
|
| CustomTableSytle | PivotTableStyle |
None. |
|
| CustomTableStyleName | string |
None. |
|
| Parent | Object |
None. |