XlPivotFormatType Enum
Definition
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.
Specifies the type of report formatting to be applied to the specified PivotTable report.
public enum class XlPivotFormatTypepublic enum XlPivotFormatTypePublic Enum XlPivotFormatType- Inheritance
-
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. |