Edit

XlPivotCellType Enum

  • Reference

Definition

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

Specifies the PivotTable entity the cell corresponds to.

public enum class XlPivotCellType
public enum XlPivotCellType
Public Enum XlPivotCellType
Inheritance
Enum
XlPivotCellType

Fields

xlPivotCellBlankCell 9

A structural blank cell in the PivotTable.
xlPivotCellCustomSubtotal 7

A cell in the row or column area that is a custom subtotal.
xlPivotCellDataField 4

A data field label (not the Data button).
xlPivotCellDataPivotField 8

The Data button.
xlPivotCellGrandTotal 3

A cell in a row or column area which is a grand total.
xlPivotCellPageFieldItem 6

The cell that shows the selected item of a Page field.
xlPivotCellPivotField 5

The button for a field (not the Data button).
xlPivotCellPivotItem 1

A cell in the row or column area which is not a subtotal, grand total, custom subtotal, or blank line.
xlPivotCellSubtotal 2

A cell in the row or column area which is a subtotal.
xlPivotCellValue 0

Any cell in the data area (except a blank row).

Applies to