PivotAreaType
PivotAreaType enumeration
Indicates the type of rule being used to describe an area or aspect of the PivotTable.
Values
| Name | Value | Description |
|---|---|---|
| None | 0 | No Pivot area. |
| Normal | 1 | Represents a header or item. |
| Data | 2 | Represents something in the data area. |
| All | 3 | Represents the whole PivotTable. |
| Origin | 4 | Represents the blank cells at the top-left of the PivotTable (top-right for RTL sheets). |
| Button | 5 | Represents a field button. |
| TopRight | 6 | Represents the blank cells at the top-right of the PivotTable (top-left for RTL sheets). |