XlPivotFormatType XlPivotFormatType XlPivotFormatType Enum

Definition

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
XlPivotFormatTypeXlPivotFormatTypeXlPivotFormatType

Fields

xlPTClassic xlPTClassic xlPTClassic 20

PivotTable classic format.

xlPTNone xlPTNone xlPTNone 21

Does not apply formatting to the PivotTable report.

xlReport1 xlReport1 xlReport1 0

Use the xlReport1 formatting for the PivotTable.

xlReport10 xlReport10 xlReport10 9

Use the xlReport10 formatting for the PivotTable.

xlReport2 xlReport2 xlReport2 1

Use the xlReport2 formatting for the PivotTable.

xlReport3 xlReport3 xlReport3 2

Use the xlReport3 formatting for the PivotTable.

xlReport4 xlReport4 xlReport4 3

Use the xlReport4 formatting for the PivotTable.

xlReport5 xlReport5 xlReport5 4

Use the xlReport5 formatting for the PivotTable.

xlReport6 xlReport6 xlReport6 5

Use the xlReport6 formatting for the PivotTable.

xlReport7 xlReport7 xlReport7 6

Use the xlReport7 formatting for the PivotTable.

xlReport8 xlReport8 xlReport8 7

Use the xlReport8 formatting for the PivotTable.

xlReport9 xlReport9 xlReport9 8

Use the xlReport9 formatting for the PivotTable.

xlTable1 xlTable1 xlTable1 10

Use the xlReport1 formatting for the PivotTable.

xlTable10 xlTable10 xlTable10 19

Use the xlReport1 formatting for the PivotTable.

xlTable2 xlTable2 xlTable2 11

Use the xlTable2 formatting for the PivotTable.

xlTable3 xlTable3 xlTable3 12

Use the xlTable3 formatting for the PivotTable.

xlTable4 xlTable4 xlTable4 13

Use the xlTable4 formatting for the PivotTable.

xlTable5 xlTable5 xlTable5 14

Use the xlTable5 formatting for the PivotTable.

xlTable6 xlTable6 xlTable6 15

Use the xlTable6 formatting for the PivotTable.

xlTable7 xlTable7 xlTable7 16

Use the xlTable7 formatting for the PivotTable.

xlTable8 xlTable8 xlTable8 17

Use the xlTable8 formatting for the PivotTable.

xlTable9 xlTable9 xlTable9 18

Use the xlTable9 formatting for the PivotTable.

Applies to