Skip to main content
Row

PivotTable Properties

Represents a PivotTable report on a worksheet.
Name Description
BandedColumns Gets or sets a value indicating whether alternate shading should be applied to the pivot table columns.
BandedRows Gets or sets a value indicating whether alternate shading should be applied to the pivot table rows.
Behavior Provides access to an object that allows you to apply restrictions on different PivotTable operations.
Cache Returns the data cache for the specified PivotTable report.
CalculatedFields Provides access to the collection of calculated fields in the specified PivotTable report.
ColumnFields Provides access to the collection of fields located in the column axis area of the PivotTable report.
DataFields Provides access to the collection of fields located in the data area of the PivotTable report.
Fields Provides access to the collection of all fields in the PivotTable report.
Filters Provides access to the collection of filters applied to the current pivot table.
Layout Provides access to options used to adjust the PivotTable report layout.
Location Provides access to an object that contains information about the location of a pivot table and its regions.
Name Gets or sets the PivotTable name.
PageFields Provides access to the collection of fields located in the PivotTable’s report filter area.
RowFields Provides access to the collection of fields located in the row axis area of the PivotTable report.
ShowColumnHeaders Gets or sets a value indicating whether to apply the style formatting to column headers.
ShowRowHeaders Gets or sets a value indicating whether to apply the style formatting to row headers.
Style Gets or sets the style applied to the pivot table.
Tag Gets or sets custom information associated with a pivot table.
View Provides access to the display settings of a PivotTable report.
See Also