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. |
PivotShowValuesSetting | Represents the settings about showing values as when the ShowDataAs calculation is in use. |
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. |
PivotTableRefreshOption | Represents the options of refreshing data source of the pivot table. |
SxRng |
Enumerations
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 . |
PivotItemPositionType | Represents the position type of the pivot base item in the base field when the ShowDataAs calculation is in use. |
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. |
ReserveMissingPivotItemType | Represents how to keep the missing pivot items. |