.NET Framework 4.5.2+
.NET Framework 4.5.2+
.NET Standard 2.0+
Row

PivotTable Members

Represents a PivotTable report on a worksheet.

Properties

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.

Methods

Name Description
BeginUpdate() Locks the PivotTable object by preventing visual updates until the EndUpdate method is called.
ChangeDataSource(CellRange) Changes the data source for the PivotTable report.
ChangeDataSource(PivotCache) Changes the data source for the PivotTable report.
Clear() Removes all fields, formatting and report filters from the PivotTable report.
EndUpdate() Unlocks the PivotTable object after a call to the BeginUpdate method and causes an immediate visual update.
MoveTo(CellRange) Moves a pivot table to the specified location.
See Also