XlPivotCellType Enumeration

Specifies the PivotTable entity the cell corresponds to.

Namespace:  Microsoft.Office.Interop.Excel
Assembly:  Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)

public enum XlPivotCellType

Member nameDescription
xlPivotCellValueAny cell in the data area (except a blank row).
xlPivotCellPivotItemA cell in the row or column area which is not a subtotal, grand total, custom subtotal, or blank line.
xlPivotCellSubtotalA cell in the row or column area which is a subtotal.
xlPivotCellGrandTotalA cell in a row or column area which is a grand total.
xlPivotCellDataFieldA data field label (not the Data button).
xlPivotCellPivotFieldThe button for a field (not the Data button).
xlPivotCellPageFieldItemThe cell that shows the selected item of a Page field.
xlPivotCellCustomSubtotalA cell in the row or column area that is a custom subtotal.
xlPivotCellDataPivotFieldThe Data button.
xlPivotCellBlankCellA structural blank cell in the PivotTable.
Show: