PivotTable.Format Method

Sets a PivotTable report to one of the predefined indented, nonindented, or cross-tabulated formats.

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

Syntax

'Declaration
Sub Format ( _
    Format As XlPivotFormatType _
)
'Usage
Dim instance As PivotTable
Dim Format As XlPivotFormatType

instance.Format(Format)

void Format(
    XlPivotFormatType Format
)

Parameters

• Format
  Type: Microsoft.Office.Interop.Excel.XlPivotFormatType

  Required XlPivotFormatType. Specifies the type of report formatting to be applied to the specified PivotTable report.

See Also

Reference

PivotTable Interface

PivotTable Members

Microsoft.Office.Interop.Excel Namespace