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). |