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)

Usage

Public Class ivotFieldsImplementation
    Implements PivotFields
End Class
Dim ivotFieldsImplementation1 As New ivotFieldsImplementation()

Syntax

Public Interface PivotFields

public interface PivotFields

public interface class PivotFields

public interface PivotFields

public interface PivotFields

Remarks

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

Platforms

Development Platforms

Windows XP Home Edition, Windows XP Professional, Windows Server 2003, and Windows 2000

Target Platforms

See Also

Reference

Microsoft.Office.Interop.Excel Namespace

Other Resources

PivotFields Members