XlPivotCellType Enum

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

Name	Value	Description
xlPivotCellValue	0	Any cell in the data area (except a blank row).
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.
xlPivotCellGrandTotal	3	A cell in a row or column area which is a grand total.
xlPivotCellDataField	4	A data field label (not the Data button).
xlPivotCellPivotField	5	The button for a field (not the Data button).
xlPivotCellPageFieldItem	6	The cell that shows the selected item of a Page field.
xlPivotCellCustomSubtotal	7	A cell in the row or column area that is a custom subtotal.
xlPivotCellDataPivotField	8	The Data button.
xlPivotCellBlankCell	9	A structural blank cell in the PivotTable.