Show / Hide Table of Contents

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

ExcelPivotTableCollection

A collection of pivottable objects

ExcelPivotTableDataField

A pivo 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 field Item. Used for grouping

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

ePivotFieldAxis

Defines the axis for a PivotTable

eShowDataAs

The data formats for a field in the PivotTable

eSortType

Sorting

eSourceType

Source type for a pivottable

eSubTotalFunctions

Built-in subtotal functions

Back to top Generated by DocFX