This topic has not yet been rated - Rate this topic

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)
[InterfaceTypeAttribute()]
[GuidAttribute("00020875-0000-0000-C000-000000000046")]
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:

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.