ExcelPivotTable Properties

Office Open XML

The ExcelPivotTable type exposes the following members.

Properties

  NameDescription
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

See Also