PivotField.LayoutForm Property

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.

Returns or sets the way the specified PivotTable items appear — in table format or in outline format. Read/write XlLayoutFormType.

public:
 property Microsoft::Office::Interop::Excel::XlLayoutFormType LayoutForm { Microsoft::Office::Interop::Excel::XlLayoutFormType get(); void set(Microsoft::Office::Interop::Excel::XlLayoutFormType value); };

public Microsoft.Office.Interop.Excel.XlLayoutFormType LayoutForm { get; set; }

Public Property LayoutForm As XlLayoutFormType

Property Value

XlLayoutFormType

Remarks

You can set this property for any PivotTable field; however, the formatting appears only if the specified field is a row field other than the innermost (lowest-level row field. For non-OLAP data sources, the value of this property doesn’t change when the field is rearranged or when it is added to or removed from the PivotTable report.

Applies to