Share via


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)

Syntax

'Declaration
Public Enumeration XlPivotCellType
'Usage
Dim instance As XlPivotCellType
public enum XlPivotCellType

Members

Member name Description
xlPivotCellValue Any cell in the data area (except a blank row).
xlPivotCellPivotItem A cell in the row or column area which is not a subtotal, grand total, custom subtotal, or blank line.
xlPivotCellSubtotal A cell in the row or column area which is a subtotal.
xlPivotCellGrandTotal A cell in a row or column area which is a grand total.
xlPivotCellDataField A data field label (not the Data button).
xlPivotCellPivotField The button for a field (not the Data button).
xlPivotCellPageFieldItem The cell that shows the selected item of a Page field.
xlPivotCellCustomSubtotal A cell in the row or column area that is a custom subtotal.
xlPivotCellDataPivotField The Data button.
xlPivotCellBlankCell A structural blank cell in the PivotTable.

See Also

Reference

Microsoft.Office.Interop.Excel Namespace