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
ExcelPivotTableAreaConditionalFormatting
Defines an area for conditional formatting within a pivot table.
ExcelPivotTableAreaConditionalFormattingCollection
A collection of pivot areas used for conditional formatting
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
ExcelPivotTableConditionalFormatting
Defines a pivot table area of selection used for styling.
ExcelPivotTableConditionalFormattingCollection
A collection of pivot areas used for styling a pivot table.
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¶
The scope of the pivot table conditional formatting rule
Conditional Formatting Evaluation Type
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