officefileapi-devexpress-dot-spreadsheet-dot-pivottable-dot-underscore-properties.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. |
See Also