Aspose.Cells.Pivot

The Aspose.Cells.Pivot namespace contains all classes of rendering and manipulating PivotTable in Excel Spreadsheet files.

Classes

Class	Description
CustomPiovtFieldGroupItem	Represents an item of custom grouped field.
PivotArea	Presents the selected area of the PivotTable.
PivotAreaFilter	Represents the filter of PivotArea for PivotTable.
PivotAreaFilterCollection	Represents the list of filters for PivotArea
PivotDateTimeRangeGroupSettings	Represents the field grouped by date time range.
PivotDiscreteGroupSettings	Rrepsents the discrete group of pivot field
PivotField	Represents a field in a PivotTable report.
PivotFieldCollection	Represents a collection of all the PivotField objects in the PivotTable’s specific PivotFields type.
PivotFieldGroupSettings	Represents the group setting of pivot field.
PivotFilter	Represents a PivotFilter in PivotFilter Collection.
PivotFilterCollection	Represents a collection of all the PivotFilter objects
PivotFormatCondition	Represents a PivotTable Format Condition in PivotFormatCondition Collection.
PivotFormatConditionCollection	Represents PivotTable Format Conditions.
PivotItem	Represents a item in a PivotField report.
PivotItemCollection	Represents a collection of all the PivotItem objects in the PivotField’s
PivotNumbericRangeGroupSettings	Represents the numberic range group of the pivot field.
PivotPageFields	Represents the pivot page field items if the pivot table data source is consolidation ranges. It only can contain up to 4 fields.
PivotTable	Summary description for PivotTable.
PivotTableCollection	Represents the collection of all the PivotTable objects on the specified worksheet.
PivotTableFormat	Represents the format defined in the PivotTable.
PivotTableFormatCollection	Represents the collection of formats applied to PivotTable.
SxRng

Enumeration

Enumeration	Description
PivotAreaType	Indicates the type of rule being used to describe an area or aspect of the PivotTable.
PivotConditionFormatRuleType	Represents PivotTable condition formatting rule type.
PivotConditionFormatScopeType	Represents PivotTable condition formatting scope type.
PivotFieldDataDisplayFormat	Represents data display format in the PivotTable data field.
PivotFieldGroupType	Represents the group type of pivot field.
PivotFieldSubtotalType	Summary description for PivotFieldSubtotalType.
PivotFieldType	Represents PivotTable field type.
PivotFilterType	Represents PivotTable Filter type.
PivotGroupByType	Represents group by type.
PivotItemPosition	Represents PivotTable base item Next/Previous/All position in the base field .
PivotMissingItemLimitType	Represents number of items to retain per field.
PivotTableAutoFormatType	Represents PivotTable auto format type.
PivotTableSelectionType	Specifies what can be selected in a PivotTable during a structured selection. These constants can be combined to select multiple types.
PivotTableStyleType	Represents the pivot table style type.