Enum ePivotAreaType¶

Namespace: OfficeOpenXml.Table.PivotTable
Assembly: EPPlus.dll

Defines the pivot area affected by a style

public enum ePivotAreaType

Fields¶

All = 0

Refers to the whole pivot table

FieldButton = 1

Refers to a field button

Data = 2

Refers to data in the data area.

None = 3

Refers to no pivot area

Normal = 4

Refers to a header or item

Origin = 5

Refers to the blank cells at the top-left(LTR sheets) or bottom-right(RTL sheets) of the pivot table.

TopEnd = 6

Refers to the blank cells at the top of the pivot table, on its trailing edge.