ExcelPivotTable Properties
From Office Open XML
The ExcelPivotTable type exposes the following members.
Properties
| Name | Description | |
|---|---|---|
 | Address |
The location of the pivot table
|
| ApplyBorderFormats |
If true apply legacy table autoformat border properties
|
| ApplyFontFormats |
If true apply legacy table autoformat font properties
|
| ApplyNumberFormats |
if true apply legacy table autoformat number format properties.
|
| ApplyPatternFormats |
If true apply legacy table autoformat pattern properties
|
| ApplyWidthHeightFormats |
If true apply legacy table autoformat width/height properties.
|
| CacheDefinition |
Reference to the pivot table cache definition object
|
| ColumGrandTotals |
If the grand totals should be displayed for the PivotTable columns
|
| ColumnFields |
Column label fields
|
| Compact |
A boolean that indicates whether new fields should have their compact flag set to true
|
| CompactData |
A boolean that indicates whether the field next to the data field in the PivotTable should be displayed in the same column of the spreadsheet
|
| DataCaption |
Specifies the name of the value area field header in the PivotTable.
This caption is shown when the PivotTable when two or more fields are in the values area.
|
| DataFields |
Value fields
|
| DataOnRows |
If multiple datafields are displayed in the row area or the column area
|
| EnableDrill |
If the user is prevented from drilling down on a PivotItem or aggregate value
|
| ErrorCaption |
The string to be displayed in cells that contain errors.
|
| FieldPrintTitles |
If the row and column titles from the PivotTable should be printed.
|
| Fields |
The fields in the table
|
| FirstDataCol |
Specifies the first column of the PivotTable data, relative to the top left cell in the ref value
|
| FirstDataRow |
Specifies the first column of the PivotTable data, relative to the top left cell in the ref value
|
| FirstHeaderRow |
Specifies the first row of the PivotTable header, relative to the top left cell in the ref value
|
| GrandTotalCaption |
Specifies the string to be displayed for grand totals.
|
| GridDropZones |
A boolean that indicates whether the in-grid drop zones should be displayed at runtime, and whether classic layout is applied
|
| Indent |
Specifies the indentation increment for compact axis and can be used to set the Report Layout to Compact Form
|
| ItemPrintTitles |
If the row and column titles from the PivotTable should be printed.
|
| MissingCaption |
Specifies the string to be displayed in cells with no value
|
| MultipleFieldFilters |
A boolean that indicates whether the fields of a PivotTable can have multiple filters set on them
|
| Name |
Name of the pivottable object in Excel
|
| Outline |
a boolean that indicates whether new fields should have their outline flag set to true
|
| OutlineData |
A boolean that indicates whether data fields in the PivotTable should be displayed in outline form
|
| PageFields |
Report filter fields
|
| PageWrap |
The number of page fields to display before starting another row or column
|
| PivotTableUri |
The package internal URI to the pivottable Xml Document.
|
| PivotTableXml |
Provides access to the XML data representing the pivottable in the package.
|
| PrintDrill |
If the drill indicators expand collapse buttons should be printed.
|
| RowFields |
Row label fields
|
| RowGrandTotals |
If the grand totals should be displayed for the PivotTable rows
|
| RowHeaderCaption |
Specifies the string to be displayed in row header in compact mode.
|
| ShowCalcMember |
Show the drill indicators
|
| ShowDataTips |
If the tooltips should be displayed for PivotTable data cells.
|
| ShowDrill |
Show the drill down buttons
|
| ShowError |
Indicates whether to show error messages in cells.
|
| ShowHeaders |
Show field headers
|
| ShowMemberPropertyTips |
Show member property information
|
| StyleName |
Pivot style name. Used for custom styles
|
| TableStyle |
The table style. If this property is cusom the style from the StyleName propery is used.
|
| UseAutoFormatting |
A boolean that indicates whether legacy auto formatting has been applied to the PivotTable view
|
| WorkSheet |
The worksheet where the pivottable is located
|
