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
Syntax
Public Enum XlPivotFormatType
public enum XlPivotFormatType
public enum class XlPivotFormatType
public enum XlPivotFormatType
public enum XlPivotFormatType
Members
| Member name | Description |
|---|---|
| xlPTClassic | PivotTable classic format. |
| xlPTNone | Does not apply formatting to the PivotTable report. |
| xlReport1 | Use the xlReport1 formatting for the PivotTable. |
| xlReport10 | Use the xlReport10 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. |
| xlTable1 | Use the xlReport1 formatting for the PivotTable. |
| xlTable10 | 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. |
Platforms
Development Platforms
Windows XP Home Edition, Windows XP Professional, Windows Server 2003, and Windows 2000