PivotField.Hidden Property
This property is used to hide the individual levels of an OLAP hierarchy. Read/write.
Namespace: Microsoft.Office.Interop.Excel
Assembly: Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)
Syntax
'Declaration
Property Hidden As Boolean
Get
Set
'Usage
Dim instance As PivotField
Dim value As Boolean
value = instance.Hidden
instance.Hidden = value
bool Hidden { get; set; }
Property Value
Type: System.Boolean
Boolean
Remarks
Returns True for hidden levels and False for visible (non-hidden) levels.
This property is applicable only to levels of OLAP hierarchies.
For relational data sources and OLAP attributes, this property is always False. Trying to set it to True for an attribute or a relational field will return a run-time error. It is not possible to set this property to True for a level if all other levels of the same hierarchy already have this setting set to True. At least one level of a hierarchy has to have this property set to False. Attempting to do this will return a run-time error.