PivotCell.PivotCellType Property
Returns a constant that identifies 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
ReadOnly Property PivotCellType As XlPivotCellType
Get
'Usage
Dim instance As PivotCell
Dim value As XlPivotCellType
value = instance.PivotCellType
XlPivotCellType PivotCellType { get; }
Property Value
Type: Microsoft.Office.Interop.Excel.XlPivotCellType
Remarks
XlPivotCellType can be one of the following XlPivotCellType constants:
xlPivotCellBlankCell A structural blank cell in the PivotTable.
xlPivotCellCustomSubtotal A cell in the row or column area that is a custom subtotal.
xlPivotCellDataField A data field label (not the Data button).
xlPivotCellDataPivotField The Data button.
xlPivotCellGrandTotal A cell in a row or column area which is a grand total.
xlPivotCellPageFieldItem The cell that shows the selected item of a Page field.
xlPivotCellPivotField The button for a field (not the Data button).
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.
xlPivotCellValue Any cell in the data area (except a blank row).