This documentation is archived and is not being maintained.

PivotFields Interface

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)

public interface PivotFields : IEnumerable

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: