XlPivotFormatType enumeration
Office 2013 and later
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)
| Member name | Description | |
|---|---|---|
| xlReport1 | Use the xlReport1 formatting for the PivotTable. | |
| xlReport2 | Use the xlReport2 formatting for the PivotTable. | |
| xlReport3 | Use the xlReport3 formatting for the PivotTable. | |
| xlReport4 | Use the xlReport4 formatting for the PivotTable. | |
| xlReport5 | Use the xlReport5 formatting for the PivotTable. | |
| xlReport6 | Use the xlReport6 formatting for the PivotTable. | |
| xlReport7 | Use the xlReport7 formatting for the PivotTable. | |
| xlReport8 | Use the xlReport8 formatting for the PivotTable. | |
| xlReport9 | Use the xlReport9 formatting for the PivotTable. | |
| xlReport10 | Use the xlReport10 formatting for the PivotTable. | |
| xlTable1 | Use the xlReport1 formatting for the PivotTable. | |
| xlTable2 | Use the xlTable2 formatting for the PivotTable. | |
| xlTable3 | Use the xlTable3 formatting for the PivotTable. | |
| xlTable4 | Use the xlTable4 formatting for the PivotTable. | |
| xlTable5 | Use the xlTable5 formatting for the PivotTable. | |
| xlTable6 | Use the xlTable6 formatting for the PivotTable. | |
| xlTable7 | Use the xlTable7 formatting for the PivotTable. | |
| xlTable8 | Use the xlTable8 formatting for the PivotTable. | |
| xlTable9 | Use the xlTable9 formatting for the PivotTable. | |
| xlTable10 | Use the xlReport1 formatting for the PivotTable. | |
| xlPTClassic | PivotTable classic format. | |
| xlPTNone | Does not apply formatting to the PivotTable report. |
Show: