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)
Syntax
'Declaration
<InterfaceTypeAttribute()> _
<GuidAttribute("00020875-0000-0000-C000-000000000046")> _
Public Interface PivotFields _
Inherits IEnumerable
'Usage
Dim instance As PivotFields
[InterfaceTypeAttribute()]
[GuidAttribute("00020875-0000-0000-C000-000000000046")]
public interface PivotFields : IEnumerable
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