PivotTable Properties
Represents a PivotTable report on a worksheet.
Name | Description |
---|---|
Banded |
Gets or sets a value indicating whether alternate shading should be applied to the pivot table columns. |
Banded |
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 Pivot |
Cache |
Returns the data cache for the specified Pivot |
Calculated |
Provides access to the collection of calculated fields in the specified Pivot |
Column |
Provides access to the collection of fields located in the column axis area of the Pivot |
Data |
Provides access to the collection of fields located in the data area of the Pivot |
Fields |
Provides access to the collection of all fields in the Pivot |
Filters | Provides access to the collection of filters applied to the current pivot table. |
Layout |
Provides access to options used to adjust the Pivot |
Location | Provides access to an object that contains information about the location of a pivot table and its regions. |
Name |
Gets or sets the Pivot |
Page |
Provides access to the collection of fields located in the Pivot |
Row |
Provides access to the collection of fields located in the row axis area of the Pivot |
Show |
Gets or sets a value indicating whether to apply the style formatting to column headers. |
Show |
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 Pivot |
See Also