PivotTable.PageFields[Object] Property

Definition

Namespace:

Microsoft.Office.Interop.Excel

Assembly:

Microsoft.Office.Interop.Excel.dll

Returns an object that represents either a single PivotTable field (a PivotField object) or a collection of all the fields (a PivotFields object) that are currently showing as page fields. Read-only.

public:
 property System::Object ^ PageFields[System::Object ^] { System::Object ^ get(System::Object ^ Index); };

public object PageFields[object Index] { get; }

Public ReadOnly Property PageFields(Optional Index As Object) As Object

Parameters

Index

Object

Optional Object. The name or number of the field to be returned (can be an array to specify more than one field).

Property Value

Object

Remarks

A hierarchy can contain only one page field.

For a PivotTable report based on a PivotTable cache, the collection of PivotTable fields that’s returned reflects what’s currently in the cache.