|
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.
|