PivotCell Members
Include Protected Members
Include Inherited Members
Represents a cell in a PivotTable report.
The PivotCell type exposes the following members.
Properties
| Name | Description | |
|---|---|---|
.gif "Public property") |
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. |
Top
Methods
| Name | Description | |
|---|---|---|
.gif "Public method") |
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. |
Top