| | Name | Description |
|---|
 | addDataField | Adds a data field to a PivotTable report. Returns a PivotField object that represents the new data field. |
| clearAllFilters | Deletes all filters currently applied to the PivotTable. This includes deleting all filters in the PivotFilters collection of the PivotTable object, removing any manual filtering applied, and setting all PivotFields in the Report Filter area to the default item. |
| clearTable | Clears a PivotTable. Clearing PivotTables includes removing all the fields and deleting all filtering and sorting applied to the PivotTables. This method resets the PivotTable to the state it had right after it was created, before any fields were added to it. |
| getAllowMultipleFilters | Gets a value that indicates whether a PivotField can have multiple filters applied to it at the same time. |
| getCalculatedFields | Returns a CalculatedFields collection that represents all the calculated fields in the specified PivotTable report. |
| getColumnFields | Returns an object that represents a collection of all the fields that are currently shown as column fields. Read-only. |
| getColumnGrand | Gets whether the PivotTable report shows grand totals for columns. |
| getColumnRange | Returns a Range object that represents the range that contains the column area in the PivotTable report. |
| getCompactRowIndent | Returns the indent increment for PivotItems when compact row layout form is turned on. |
| getDataBodyRange | Returns a Range object that represents the range that contains the data area in the list between the header row and the insert row. |
| getDataFields | Returns an object that represents a collection of all the fields that are currently shown as data fields. Read-only. |
| getDeferLayoutUpdate | Returns whether the pivotTable defer layout update. |
| getDisplayContextTooltips | Gets whether tooltips are displayed for PivotTable cells. |
| getDisplayErrorString | Gets if the PivotTable report displays a custom error string in cells that contain errors. The default value is False. |
| getDisplayMemberPropertyTooltips | Gets whether to display member properties in tooltips. |
| getDisplayNullString | Gets if the PivotTable report displays a custom string in cells that contain null values. The default value is True. |
| getErrorString | Returns the string displayed in cells that contain errors when the PivotTable.getDisplayErrorString() is True. The default value is an empty string (""). |
| getGrandTotalName | Gets the text string label that is displayed in the grand total column or row heading in the specified PivotTable report. The default value is the string "Grand Total". |
| getHasAutoFormat | Gets a value indicating whether the PivotTable report automatically adjusts column width when refreshed. Default value is true. |
| getLayoutRowDefault | Gets the default layout settings for PivotFields when they are added to the PivotTable for the first time. |
| getMergeLabels | Gets if the specified PivotTable reportĄ¯s outer-row item, column item, subtotal, and grand total labels use merged cells. |
| getName | Gets the name of the object. |
| getNullString | Returns the string displayed in cells that contain null values when the PivotTable.DisplayNullString property is True. The default value is an empty string (""). |
| getPageFieldOrder | Returns the order in which page fields are added to the PivotTable reportĄ¯s layout. Can be one of the following Order constants: DownThenOver or OverThenDown. The default constant is DownThenOver. |
| getPageFields | Returns an object that represents a collection of all the fields that are currently showing as page fields. Read-only. |
| getPageFieldWrapCount | Returns the number of page fields in each column or row in the PivotTable report. |
| getPageRange | Returns a Range object that represents the range that contains the page area in the PivotTable report. |
| getPivotCache | Returns a PivotCache object that represents the cache for the specified PivotTable report. |
| getPivotColumnAxis | Returns a PivotAxis object representing the entire column axis. |
| getPivotFields | Returns an object that represents either a single PivotTable field (a PivotField object) or a collection of both the visible and hidden fields (a PivotFields object) in the PivotTable report. |
| getPivotFormulas | Gets a PivotFormulas object that represents the collection of formulas for the specified PivotTable report. |
| getPivotRowAxis | Returns a PivotAxis object representing the entire row axis. |
| getRowFields | Returns an object that represents either a collection of all the fields that are currently showing as row fields. Read-only. |
| getRowGrand | Gets whether the PivotTable report shows grand totals for rows. |
| getRowRange | Returns a Range object that represents the range including the row area on the PivotTable report. |
| getShowTableStyleColumnHeaders | Gets the boolean value if the column headers should be displayed in the PivotTable. |
| getShowTableStyleColumnStripes | Gets the boolean value displays banded columns in which even columns are formatted differently from odd columns. This makes PivotTableseasier to read. |
| getShowTableStyleLastColumn | Gets the boolean value if displays grand total columns style. |
| getShowTableStyleRowHeaders | Gets the boolean value if the row headers should be displayed in the PivotTable. |
| getShowTableStyleRowStripes | Gets the boolean value displays banded rows in which even rows are formatted differently from odd rows. This makes PivotTables easier to read. |
| getStyle | Gets the style currently applied to the specified pivot table. |
| getTableRange1 | Returns a Range object that represents the range containing the entire PivotTable report, but doesnĄ¯t include page fields. |
| getTableRange2 | Returns a Range object that represents the range containing the entire PivotTable report, including page fields. |
| getTableStyle | Gets the style used in the body of the PivotTable report. The default value is a null string (no style is applied by default). |
| getTag | Gets a string saved with the PivotTable report. |
| pivotValueCell | Retrieve the PivotValueCell object for a given PivotTable provided certain row and column indices. |
| refresh | Refreshes the PivotTable report from the source data. Returns True if itĄ¯s successful. |
| repeatAllLabels | Sets whether to repeat item labels for all PivotFields in the specified PivotTable. |
| setAllowMultipleFilters | Sets a value that indicates whether a PivotField can have multiple filters applied to it at the same time. |
| setColumnGrand | Sets whether the PivotTable report shows grand totals for columns. |
| setCompactRowIndent | Sets the indent increment for PivotItems when compact row layout form is turned on. |
| setDeferLayoutUpdate | Sets whether the pivotTable defer layout update. |
| setDisplayContextTooltips | Sets whether tooltips are displayed for PivotTable cells. |
| setDisplayErrorString | Sets if the PivotTable report displays a custom error string in cells that contain errors. |
| setDisplayMemberPropertyTooltips | Sets whether to display member properties in tooltips. |
| setDisplayNullString | Sets if the PivotTable report displays a custom string in cells that contain null values. |
| setErrorString | Sets the string displayed in cells that contain errors when the PivotTable.getDisplayErrorString() is True. |
| setGrandTotalName | Sets the text string label that is displayed in the grand total column or row heading in the specified PivotTable report. The default value is the string "Grand Total". |
| setHasAutoFormat | Sets a value indicating whether the PivotTable report automatically adjusts column width when refreshed. |
| setLayoutRowDefault | Sets the default layout settings for PivotFields when they are added to the PivotTable for the first time. |
| setMergeLabels | Sets if the specified PivotTable reportĄ¯s outer-row item, column item, subtotal, and grand total labels use merged cells. |
| setName | Sets the name of the object. |
| setNullString | Sets the string displayed in cells that contain null values when the PivotTable.DisplayNullString property is True. |
| setPageFieldOrder | Sets the order in which page fields are added to the PivotTable reportĄ¯s layout. Can be one of the following Order constants: DownThenOver or OverThenDown. The default constant is DownThenOver. |
| setPageFieldWrapCount | Sets the number of page fields in each column or row in the PivotTable report. |
| setRowAxisLayout | This method is used for simultaneously setting layout options for all existing PivotFields. |
| setRowGrand | Sets whether the PivotTable report shows grand totals for rows. |
| setShowTableStyleColumnHeaders | Sets if the column headers should be displayed in the PivotTable. |
| setShowTableStyleColumnStripes | Sets the boolean value displays banded columns in which even columns are formatted differently from odd columns. This makes PivotTableseasier to read. |
| setShowTableStyleLastColumn | Sets the boolean value if displays grand total columns style. |
| setShowTableStyleRowHeaders | Sets the boolean value if the row headers should be displayed in the PivotTable. |
| setShowTableStyleRowStripes | Sets the boolean value displays banded rows in which even rows are formatted differently from odd rows. This makes PivotTables easier to read. |
| setStyle | Sets the style currently applied to the specified pivot table. |
| setTableStyle | Sets the style used in the body of the PivotTable report. The default value is a null string (no style is applied by default). |
| setTag | Sets a string saved with the PivotTable report. |
| subtotalLocation | Changes the subtotal location for all existing PivotFields. Changing the subtotal location has an immediate visual effect only for fields in outline form, but it will be set for fields in tabular form as well. |
| update | Updates the link or PivotTable report. |
