Namespace OfficeOpenXml.Table.PivotTable

Classes

ExcelPivotArea

Defines a pivot table area of selection used for different purposes.

ExcelPivotAreaAutoSort

Defines sorting for a pivot table area within a pivot table.

ExcelPivotAreaDataFieldReference

A collection of data fields used in a pivot area selection

ExcelPivotAreaReference

A reference to a field in a pivot area

ExcelPivotAreaReferenceBase

Base class for pivot area references

ExcelPivotAreaReferenceCollection

A collection of pivot area references. A pivot area reference is a reference to a column, row field or a data field

ExcelPivotAreaReferenceItems

A list of pivot item refernces

ExcelPivotAreaStyleConditions

Conditions for a pivot table area style.

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

ExcelPivotTableAreaStyle

Defines a pivot table area of selection used for styling.

ExcelPivotTableAreaStyleCollection

A collection of pivot areas used for styling a pivot table.

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

ExcelPivotTableDataFieldShowDataAs

Represents a pivot fields Show As properties.

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

Structs

PivotItemReference

A reference to a pivot table value item

PivotNull

Represents a null value in a pivot table caches shared items list.

Enums

DataFieldFunctions

Build-in table row functions

eDateGroupBy

Data grouping

eItemType

The item type for a pivot table field

ePivotAreaType

Defines the pivot area affected by a style

ePivotFieldAxis

Defines the axis for a PivotTable

ePivotTableAxis

Defines the axis for a pivot table

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

ePrevNextPivotItem

Compares the item to the previous or next item.

eShowDataAs

The data formats for a field in the PivotTable

eSortType

Sorting

eSourceType

Source type for a pivottable

eSubTotalFunctions

Built-in subtotal functions