PivotTable.RowAxisLayout(XlLayoutRowType) Method

Reference

Definition

Namespace:: Microsoft.Office.Interop.Excel

Assembly:: Microsoft.Office.Interop.Excel.dll

Important

Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.

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

public:
 void RowAxisLayout(Microsoft::Office::Interop::Excel::XlLayoutRowType RowLayout);

public void RowAxisLayout (Microsoft.Office.Interop.Excel.XlLayoutRowType RowLayout);

Public Sub RowAxisLayout (RowLayout As XlLayoutRowType)

Parameters

RowLayout: 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.

Applies to