PivotField Interface

Represents a field in a PivotTable report. The PivotField object is a member of the PivotFields collection. The PivotFields collection contains all the fields in a PivotTable report, including hidden fields.

Namespace:  Microsoft.Office.Interop.Excel
Assembly:  Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)

[GuidAttribute("00020874-0000-0000-C000-000000000046")]
[InterfaceTypeAttribute()]
public interface PivotField

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 properties are available:

Community Additions

ADD
Show:
© 2014 Microsoft