officefileapi-devexpress-dot-spreadsheet-dot-pivottable-dot-underscore-members.md
Represents a PivotTable report on a worksheet.
| 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. |
| Name | Description |
|---|---|
| BeginUpdate() | Locks the PivotTable object. Prevents visual updates until the EndUpdate method calls. |
| 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 you call BeginUpdate. It also causes an immediate visual update. |
| MoveTo(CellRange) | Moves a pivot table to the specified location. |
See Also