IPivotTable Members
In This Article
#Properties
Name | Description |
---|---|
Attributes | Specifies a collection of standard HTML attributes applied to the Pivot Table. |
Auto |
Specifies whether to automatically expand all groups when the Pivot loads data. |
Column |
Specifies the position of column totals. |
Css |
Assigns a CSS class to the Pivot Table. |
Data | Specifies an object that supplies Pivot Table data. |
Field |
Specifies a common template for all data cells in the Pivot Table. |
Field |
Specifies a common template to display field captions in the header area. |
Field |
Specifies a common template to display field values in rows or columns. |
Row |
Specifies the position of row totals. |
Show |
Specifies whether to display column grand totals. |
Show |
Specifies whether to display column totals. |
Show |
Specifies whether to display row grand totals. |
Show |
Specifies whether to display row totals. |
#Methods
Name | Description |
---|---|
Begin |
Suspends Pivot Table updates caused by parameter changes and method calls until the End |
Collapse |
Collapses all groups in the Pivot Table component. |
End |
Resumes Pivot Table updates (when the Begin |
Expand |
Expands all groups in the Pivot Table component. |
Get |
Returns a collection of Pivot Table fields. |
Reload() | Reloads Pivot Table data. |
See Also