PivotCell.PivotCellType Property

Definition

Namespace:

Microsoft.Office.Interop.Excel

Assembly:

Microsoft.Office.Interop.Excel.dll

Returns a constant that identifies the PivotTable entity the cell corresponds to.

public:
 property Microsoft::Office::Interop::Excel::XlPivotCellType PivotCellType { Microsoft::Office::Interop::Excel::XlPivotCellType get(); };

public Microsoft.Office.Interop.Excel.XlPivotCellType PivotCellType { get; }

Public ReadOnly Property PivotCellType As XlPivotCellType

Property Value

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