PivotFields interface
Office 2013 and later
A collection of all the PivotField objects in a PivotTable report.
Namespace: Microsoft.Office.Interop.Excel
Assembly: Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)
Use the PivotFields method of the PivotTable object to return the PivotFields collection.
Use PivotFields(index), where index is the field name or index number, to return a single PivotField object.
In some cases, it may be easier to use one of the properties that returns a subset of the PivotTable fields. The following accessor methods are available:
ColumnFields property
DataFields property
HiddenFields property
PageFields property
RowFields property
VisibleFields property
Show: