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)
Syntax
'Declaration
<GuidAttribute("00020874-0000-0000-C000-000000000046")> _
<InterfaceTypeAttribute()> _
Public Interface PivotField
'Usage
Dim instance As PivotField
[GuidAttribute("00020874-0000-0000-C000-000000000046")]
[InterfaceTypeAttribute()]
public interface PivotField
Remarks
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:
CubeFields property
DataFields property
HiddenFields property
PageFields property
RowFields property
VisibleFields property