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.
PivotAreaCollection	Represents a list of pivot area.
PivotAreaFilter	Represents the filter of PivotArea for PivotTable.
PivotAreaFilterCollection	Represents the list of filters for PivotArea
PivotConditionalFormat	Represents a PivotTable Format Condition in PivotFormatCondition Collection.
PivotConditionalFormatCollection	Represents all conditional formats of pivot table.
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.
PivotFieldSortSetting	Represents the setting for sorting pivot fields.
PivotFilter	Represents a PivotFilter in PivotFilter Collection.
PivotFilterCollection	Represents a collection of all the PivotFilters.
PivotFormatCondition
PivotFormatConditionCollection
PivotItem	Represents a item in a PivotField report.
PivotItemCollection	Represents all the PivotItem objects in the PivotField.
PivotNumbericRangeGroupSettings	Represents the numberic range group of the pivot field.
PivotPageFields	Represents the pivot page items if the pivot table data source is consolidation ranges. It only can contain up to 4 items.
PivotShowValuesSetting	Represents the settings about showing values as when the ShowDataAs calculation is in use.
PivotTable	Summary description for PivotTable.
PivotTableCalculateOption	Rerepsents the options of calculating data of the pivot table.
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.
PivotTableRefreshOption	Represents the options of refreshing data source of the pivot table.
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 the filter type of the pivot table.
PivotGroupByType	Represents group by type.
PivotItemPosition
PivotItemPositionType	Represents the position type of the pivot base item in the base field when the ShowDataAs calculation is in use.
PivotLineType	Specifies the type of the PivotLine.
PivotMissingItemLimitType	Represents number of items to retain per field.
PivotRefreshState	The state for refreshing pivot tables.
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.
PivotTableSourceType	Represents data source type of the pivot table.
PivotTableStyleType	Represents the pivot table style type.
ReserveMissingPivotItemType	Represents how to keep the missing pivot items.