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

	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.