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
- ExcelPivotTableCalculatedData
Represents a selection of a row or column field to retreive the calculated value from a pivot table.
- 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.
- 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