Namespace OfficeOpenXml.Table.PivotTable¶
Namespaces¶
OfficeOpenXml.Table.PivotTable.Calculation
OfficeOpenXml.Table.PivotTable.Filter
Classes¶
Defines a pivot table area of selection used for different purposes.
Defines sorting for a pivot table area within a pivot table.
ExcelPivotAreaDataFieldReference
A collection of data fields used in a pivot area selection
A reference to a field in a pivot area
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
A list of pivot item refernces
Conditions for a pivot table area style.
Cache definition. This class defines the source data. Note that one cache definition can be shared between many pivot tables.
An Excel Pivottable
Defines a pivot table area of selection used for styling.
ExcelPivotTableAreaStyleCollection
A collection of pivot areas used for styling a pivot table.
A pivot tables cache field
Represents a selection of a row or column field to retreive the calculated value from a pivot table.
A collection of pivottable objects
A pivot table data field
ExcelPivotTableDataFieldCollection
Collection class for data fields in a Pivottable
ExcelPivotTableDataFieldShowDataAs
Represents a pivot fields Show As properties.
A pivot table field.
ExcelPivotTableFieldCollection
A collection of pivot table fields
ExcelPivotTableFieldCollectionBase<T>
Base collection class for pivottable fields
A date group
Base class for pivot table field groups
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¶
A reference to a pivot table value item
Represents a null value in a pivot table caches shared items list.
Enums¶
Build-in table row functions
Data grouping
The item type for a pivot table field
Defines the pivot area affected by a style
Defines the axis for a PivotTable
Defines the axis for a pivot table
Defines a pivot table caption filter type
ePivotTableDatePeriodFilterType
Defines a pivot table caption period type
ePivotTableDateValueFilterType
Defines a pivot table date value filter type
Defines a pivot table filter type
Defines a pivot table top 10 filter type
Defines a pivot table value filter type for numbers and strings
Compares the item to the previous or next item.
The data formats for a field in the PivotTable
Sorting
Source type for a pivottable
Built-in subtotal functions