PivotAreaType

PivotAreaType enumeration

Utility class containing constants. Indicates the type of rule being used to describe an area or aspect of the PivotTable.

Values

Name	Description
NONE	No Pivot area.
NORMAL	Represents a header or item.
DATA	Represents something in the data area.
ALL	Represents the whole PivotTable.
ORIGIN	Represents the blank cells at the top-left of the PivotTable (top-right for RTL sheets).
BUTTON	Represents a field button.
TOP_RIGHT	Represents the blank cells at the top-right of the PivotTable (top-left for RTL sheets).