Export (0) Print
Expand All
Expand Minimize

XlPivotFormatType Enumeration 

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

Namespace: Microsoft.Office.Interop.Excel
Assembly: Microsoft.Office.Interop.Excel (in microsoft.office.interop.excel.dll)

'Usage
Dim xlPivotFormatType1 As XlPivotFormatType = XlPivotFormatType.xlPTClassic

public enum XlPivotFormatType
public enum XlPivotFormatType
public enum XlPivotFormatType

Member nameDescription
xlPTClassicPivotTable classic format.
xlPTNoneDoes not apply formatting to the PivotTable report.
xlReport1Use the xlReport1 formatting for the PivotTable.
xlReport10Use the xlReport10 formatting for the PivotTable.
xlReport2Use the xlReport2 formatting for the PivotTable.
xlReport3Use the xlReport3 formatting for the PivotTable.
xlReport4Use the xlReport4 formatting for the PivotTable.
xlReport5Use the xlReport5 formatting for the PivotTable.
xlReport6Use the xlReport6 formatting for the PivotTable.
xlReport7Use the xlReport7 formatting for the PivotTable.
xlReport8Use the xlReport8 formatting for the PivotTable.
xlReport9Use the xlReport9 formatting for the PivotTable.
xlTable1Use the xlReport1 formatting for the PivotTable.
xlTable10Use the xlReport1 formatting for the PivotTable.
xlTable2Use the xlTable2 formatting for the PivotTable.
xlTable3Use the xlTable3 formatting for the PivotTable.
xlTable4Use the xlTable4 formatting for the PivotTable.
xlTable5Use the xlTable5 formatting for the PivotTable.
xlTable6Use the xlTable6 formatting for the PivotTable.
xlTable7Use the xlTable7 formatting for the PivotTable.
xlTable8Use the xlTable8 formatting for the PivotTable.
xlTable9Use the xlTable9 formatting for the PivotTable.

Development Platforms

Windows XP Home Edition, Windows XP Professional, Windows Server 2003, and Windows 2000

Target Platforms

Community Additions

ADD
Show:
© 2014 Microsoft