Namespace DRIT.Spreadsheet.Pivot
Classes
PivotCache
Represents a cache of data for a PivotTable, storing the source data and metadata.
PivotCacheCollection
Represents a collection of pivot caches in a workbook.
PivotField
Represents a field in a PivotTable that can be placed in row, column, data, or page area.
PivotFieldCollection
Represents the pivot field collection class used by the spreadsheet model.
PivotFilterCollection
Represents a collection of advanced filters for a PivotTable.
PivotFormatCondition
Represents a conditional formatting rule for a PivotTable.
PivotItem
Represents the pivot item class used by the spreadsheet model.
PivotItemCollection
Represents a collection of pivot items within a pivot field.
PivotTable
Represents a PivotTable that summarizes and analyzes data from a worksheet range.
PivotTableAdvancedFilter
Represents a PivotTable advanced filter.
PivotTableCollection
Represents a collection of pivot table on a worksheet.
PivotTableStyle
Represents a style that can be applied to a PivotTable.
Enums
AggregationFunction
Specifies types of aggregation functions.
ConditionFormatScopeType
Specifies the scope of conditional formatting rules in a PivotTable.
PivotConditionFormatRuleType
Represents the pivot condition format rule type enumeration used by the spreadsheet model.
PivotFieldCustomCalculation
Represents pivot Field Custom Calculation in the spreadsheet object model.
PivotFieldDataDisplayFormat
Specifies how values are displayed in the data area of a PivotTable field. Excel UI: "PivotTable Analyze > Field Settings > Show Values As" dropdown.
PivotFieldType
Specifies the area of a PivotTable in which a field is placed. Excel UI: "PivotTable Fields" pane — drag fields into Filters, Columns, Rows, or Values areas.
PivotFilterType
Specifies the types of filters that can be applied to a PivotTable field.
PivotGroupByType
Specifies how a PivotField is grouped when the source data contains date or numeric values. Excel UI: "PivotTable Analyze > Group Field" dialog.
PivotItemPosition
Specifies the position of a PivotItem relative to other items in the same field. Excel UI: "PivotTable Analyze > Move" commands.
PivotStyleType
Represents the built-in pivot table styles available in the Excel "PivotTable Design > PivotTable Styles" gallery.
PivotTableAutoFormatType
Specifies the built-in auto-format styles that can be applied to a PivotTable. These correspond to the legacy Excel 2003 auto-format gallery. Excel UI: "PivotTable Options > Layout & Format > AutoFormat" (legacy).