PivotTable.RowAxisLayout Method

This method is used for simultaneously setting layout options for all existing PivotFields.

Namespace:  Microsoft.Office.Interop.Excel
Assembly:  Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)

Syntax

'Declaration
Sub RowAxisLayout ( _
    RowLayout As XlLayoutRowType _
)
'Usage
Dim instance As PivotTable
Dim RowLayout As XlLayoutRowType

instance.RowAxisLayout(RowLayout)

void RowAxisLayout(
    XlLayoutRowType RowLayout
)

Parameters

• RowLayout
  Type: Microsoft.Office.Interop.Excel.XlLayoutRowType

  Required XlLayoutRowType Can be xlCompactRow, xlTabularRow, or xlOutlineRow.

Remarks

This method is atomic so it makes sure that if layout options cannot be set on any PivotField, the layout options of none of the fields will change and no change is made to the PivotTable.

See Also

Reference

PivotTable Interface

PivotTable Members

Microsoft.Office.Interop.Excel Namespace