PivotCell Interface

Represents a cell in a PivotTable report.

Namespace:  Microsoft.Office.Interop.Excel
Assembly:  Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)

[InterfaceTypeAttribute()]
[GuidAttribute("00024458-0000-0000-C000-000000000046")]
public interface PivotCell

Use the PivotCell property of the Range collection to return a PivotCell object.

Once a PivotCell object is returned, you can use the PivotCellType property to determine what type of cell a particular range is.

You can use the ColumnItems or RowItems property to determine the PivotItems collection that corresponds to the items on the column or row axis that represents the selected number.

Show:
© 2015 Microsoft