PivotTable Methods

The PivotTable type exposes the following members.

Methods
  NameDescription
Public methodAddCalculatedField(String, String)
Adds a calculated field to pivot field and drag it to data area.
Public methodAddCalculatedField(String, String, Boolean)
Adds a calculated field to pivot field.
Public methodAddFieldToArea(PivotFieldType, PivotField)
Adds the field to the specific area.
Public methodAddFieldToArea(PivotFieldType, Int32)
Adds the field to the specific area.
Public methodAddFieldToArea(PivotFieldType, String)
Adds the field to the specific area.
Public methodCalculateData
Calculates pivottable's data to cells.
Public methodCalculateRange
Calculates pivottable's range.
Public methodChangeDataSource
Set pivottable's source data. Sheet1!$A$1:$C$3
Public methodClearData
Clear PivotTable's data and formatting
Public methodCopyStyle
Copies named style from another pivot table.
Public methodDispose
Performs application-defined tasks associated with freeing, releasing, or resetting unmanaged resources.
Public methodEquals (Inherited from Object.)
Public methodFields
Gets the specific fields by the field type.
Protected methodFinalize (Inherited from Object.)
Public methodFormat
Format the cell in the pivottable area
Public methodFormatAll
Format all the cell in the pivottable area
Public methodGetCellByDisplayName
Gets the Cell object by the DisplayName of PivotField
Public methodGetChildren
Gets the Children Pivot Tables which use this PivotTable data as data source.
Public methodGetHashCode (Inherited from Object.)
Public methodGetHorizontalBreaks
get pivot table row index list of horizontal pagebreaks
Public methodGetSource
Get pivottable's source data.
Public methodGetType (Inherited from Object.)
Protected methodMemberwiseClone (Inherited from Object.)
Public methodMove(String)
Moves the PivotTable to a different location in the worksheet.
Public methodMove(Int32, Int32)
Moves the PivotTable to a different location in the worksheet.
Public methodRefreshData
Refreshes pivottable's data and setting from it's data source.
Public methodRemoveField(PivotFieldType, PivotField)
Remove field from specific field area
Public methodRemoveField(PivotFieldType, Int32)
Removes a field from specific field area
Public methodRemoveField(PivotFieldType, String)
Removes a field from specific field area
Public methodSetAutoGroupField(Int32)
Sets auto field group by the PivotTable.
Public methodSetAutoGroupField(PivotField)
Sets auto field group by the PivotTable.
Public methodSetManualGroupField(Int32, DateTime, DateTime, ArrayList, Int32)
Sets manual field group by the PivotTable.
Public methodSetManualGroupField(Int32, Double, Double, ArrayList, Double)
Sets manual field group by the PivotTable.
Public methodSetManualGroupField(PivotField, DateTime, DateTime, ArrayList, Int32)
Sets manual field group by the PivotTable.
Public methodSetManualGroupField(PivotField, Double, Double, ArrayList, Double)
Sets manual field group by the PivotTable.
Public methodSetUngroup(Int32)
Sets ungroup by the PivotTable
Public methodSetUngroup(PivotField)
Sets ungroup by the PivotTable
Public methodShowInCompactForm
Layouts the PivotTable in compact form.
Public methodShowInOutlineForm
Layouts the PivotTable in outline form.
Public methodShowInTabularForm
Layouts the PivotTable in tabular form.
Public methodShowReportFilterPage
Show all the report filter pages according to PivotField, the PivotField must be located in the PageFields.
Public methodShowReportFilterPageByIndex
Show all the report filter pages according to the position index in the PageFields
Public methodShowReportFilterPageByName
Show all the report filter pages according to PivotField's name, the PivotField must be located in the PageFields.
Public methodToString (Inherited from Object.)
See Also