CubeField.Orientation Property
The location of the field in the specified PivotTable report.
Namespace: Microsoft.Office.Interop.Excel
Assembly: Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)
Syntax
'Declaration
Property Orientation As XlPivotFieldOrientation
Get
Set
'Usage
Dim instance As CubeField
Dim value As XlPivotFieldOrientation
value = instance.Orientation
instance.Orientation = value
XlPivotFieldOrientation Orientation { get; set; }
Property Value
Type: Microsoft.Office.Interop.Excel.XlPivotFieldOrientation
Remarks
XlPivotFieldOrientation can be one of these XlPivotFieldOrientation constants:
xlColumnField
xlDataField
xlHidden
xlPageField
xlRowField
For OLAP data sources, setting this property for one field in a hierarchy sets the orientation for the other fields in the same hierarchy. Dimension fields can only be oriented in the row, column, and page field areas of the PivotTable report. Measure fields can only be oriented in the data area. Setting a hierarchy or data field to xlHidden removes the hierarchy or field from the PivotTable report.