PivotCell Interface

Reference

Definition

Namespace:: Microsoft.Office.Interop.Excel

Assembly:: Microsoft.Office.Interop.Excel.dll

Important

Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.

Represents a cell in a PivotTable report.

public interface class PivotCell

[System.Runtime.InteropServices.Guid("00024458-0000-0000-C000-000000000046")]
[System.Runtime.InteropServices.InterfaceType(2)]
public interface PivotCell

Public Interface PivotCell

Attributes: GuidAttribute InterfaceTypeAttribute

Remarks

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.

Properties

Application	Returns an Application object that represents the Microsoft Excel application.
CellChanged	Gets whether a PivotTable value cell has been edited or recalculated since the PivotTable report was created or the last commit operation was performed.
ColumnItems	Returns a PivotItemList collection that corresponds to the items on the column axis that represent the selected range.
Creator	Returns a 32-bit integer that indicates the application in which this object was created.
CustomSubtotalFunction	Returns the custom subtotal function field setting of a PivotCell object.
DataField	Returns a PivotField object that corresponds to the selected data field.
DataSourceValue	Gets the value last retrieved from the data source for edited cells in a PivotTable report.
Dummy18	Reserved for internal use.
MDX	Gets a tuple that provides the full MDX coordinates of the specified value cell in PivotTable with an OLAP data source.
Parent	Returns the parent object for the specified object.
PivotCellType	Returns a constant that identifies the PivotTable entity the cell corresponds to.
PivotColumnLine	Returns the PivotLine on a column for a specific PivotCell object. Read-only.
PivotField	Returns a PivotField object that represents the PivotTable field containing the upper-left corner of the specified range.
PivotItem	Returns a PivotItem object that represents the PivotTable item containing the upper-left corner of the specified range.
PivotRowLine	Returns the PivotLine on a row for a specific PivotCell object. Read-only PivotLine.
PivotTable	Returns a PivotTable object that represents the PivotTable report containing the upper-left corner of the specified range, or the PivotTable report associated with the PivotChart report.
Range	Returns a Range object that represents the range the specified PivotCell applies to.
RowItems	Returns a PivotItemList collection that corresponds to the items on the category axis that represent the selected cell.
ServerActions	Represents a collection of actions consisting of OLAP-defined actions which can be executed. The actions are specific to PivotTables existing at a worksheet-level. Read-only

Methods

AllocateChange()	Performs a writeback operation on the specified cell in a PivotTable report based on an OLAP data source.
DiscardChange()	Discards changes to the specified cell in a PivotTable report.

Applies to

Share via