PivotTable Members
In This Article
#Properties
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 |
#Methods
Name | Description |
---|---|
Begin |
Locks the Pivot object. Prevents visual updates until the End method calls.
|
Change |
Changes the data source for the Pivot |
Change |
Changes the data source for the Pivot |
Clear() |
Removes all fields, formatting and report filters from the Pivot |
End |
Unlocks the Pivot object after you call Begin . It also causes an immediate visual update.
|
Move |
Moves a pivot table to the specified location. |
See Also