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. |