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. |
PivotFieldSortSetting | Represents the setting of sorting pivot fields. |
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 all the PivotItem objects in the PivotField. |
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. |
PivotTableCalculateOption | Rerepsents the options of calcuating 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. |