Namespace OfficeOpenXml.Table.PivotTable

Classes

ExcelPivotCacheDefinition

Cache definition. This class defines the source data. Note that one cache definition can be shared between many pivot tables.

ExcelPivotTable

An Excel Pivottable

ExcelPivotTableCacheField

A pivot tables cache field

ExcelPivotTableCollection

A collection of pivottable objects

ExcelPivotTableDataField

A pivot table data field

ExcelPivotTableDataFieldCollection

Collection class for data fields in a Pivottable

ExcelPivotTableField

A pivot table field.

ExcelPivotTableFieldCollection

A collection of pivot table fields

ExcelPivotTableFieldCollectionBase<T>

Base collection class for pivottable fields

ExcelPivotTableFieldDateGroup

A date group

ExcelPivotTableFieldGroup

Base class for pivot table field groups

ExcelPivotTableFieldItem

A pivot table field Item. Used for grouping.

ExcelPivotTableFieldItemsCollection

ExcelPivotTableFieldNumericGroup

A pivot table field numeric grouping

ExcelPivotTablePageFieldSettings

A page / report filter field

ExcelPivotTableRowColumnFieldCollection

Collection class for Row and column fields in a Pivottable

Enums

DataFieldFunctions

Build-in table row functions

eDateGroupBy

Data grouping

eItemType

The item type for a pivot table field

ePivotFieldAxis

Defines the axis for a PivotTable

ePivotTableCaptionFilterType

Defines a pivot table caption filter type

ePivotTableDatePeriodFilterType

Defines a pivot table caption period type

ePivotTableDateValueFilterType

Defines a pivot table date value filter type

ePivotTableFilterType

Defines a pivot table filter type

ePivotTableTop10FilterType

Defines a pivot table top 10 filter type

ePivotTableValueFilterType

Defines a pivot table value filter type for numbers and strings

eShowDataAs

The data formats for a field in the PivotTable

eSortType

Sorting

eSourceType

Source type for a pivottable

eSubTotalFunctions

Built-in subtotal functions