PivotTable.HiddenFields[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 not shown as row, column, page, or data fields. Read-only.

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

public object HiddenFields[object Index] { get; }

Public ReadOnly Property HiddenFields(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

For OLAP data sources, this property always returns an empty collection.