• DR-IT Software
  • Products
  • Documentation
  • Product page
  • Examples
  • API reference
  • Support
Show / Hide Table of Contents

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).

Back to top

DR-IT Software documentation

DR-IT Software · Products · Documentation index · Product page · Downloads · Support · Licensing

Generated by DocFX