OfficeOpenXml.Table.PivotTable Namespace
From Office Open XML
Contains classes for Excel Pivottables
Classes
| Class | Description | |
|---|---|---|
 | 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 | |
| ExcelPivotTableFieldCollectionBase<(Of <(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
|
Enumerations
| Enumeration | Description | |
|---|---|---|
 | DataFieldFunctions |
Build-in table row functions
|
| eDateGroupBy |
Data grouping
|
| ePivotFieldAxis |
Defines the axis for a PivotTable
|
| eSortType |
Sorting
|
| eSourceType | |
| eSubTotalFunctions |
Built-in subtotal functions
|
