XlPivotFormatType Enum

  • Reference

Definition

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

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

public enum class XlPivotFormatType
public enum XlPivotFormatType
Public Enum XlPivotFormatType
Inheritance
Enum
XlPivotFormatType

Fields

Name Value Description
xlReport1 0

Use the xlReport1 formatting for the PivotTable.
xlReport2 1

Use the xlReport2 formatting for the PivotTable.
xlReport3 2

Use the xlReport3 formatting for the PivotTable.
xlReport4 3

Use the xlReport4 formatting for the PivotTable.
xlReport5 4

Use the xlReport5 formatting for the PivotTable.
xlReport6 5

Use the xlReport6 formatting for the PivotTable.
xlReport7 6

Use the xlReport7 formatting for the PivotTable.
xlReport8 7

Use the xlReport8 formatting for the PivotTable.
xlReport9 8

Use the xlReport9 formatting for the PivotTable.
xlReport10 9

Use the xlReport10 formatting for the PivotTable.
xlTable1 10

Use the xlReport1 formatting for the PivotTable.
xlTable2 11

Use the xlTable2 formatting for the PivotTable.
xlTable3 12

Use the xlTable3 formatting for the PivotTable.
xlTable4 13

Use the xlTable4 formatting for the PivotTable.
xlTable5 14

Use the xlTable5 formatting for the PivotTable.
xlTable6 15

Use the xlTable6 formatting for the PivotTable.
xlTable7 16

Use the xlTable7 formatting for the PivotTable.
xlTable8 17

Use the xlTable8 formatting for the PivotTable.
xlTable9 18

Use the xlTable9 formatting for the PivotTable.
xlTable10 19

Use the xlReport1 formatting for the PivotTable.
xlPTClassic 20

PivotTable classic format.
xlPTNone 21

Does not apply formatting to the PivotTable report.

Applies to