[]
Represents a cell in a PivotTable report.
public interface IPivotCell
Public Interface IPivotCell
Name | Description |
---|---|
ColumnItems | Returns a PivotItemList collection that corresponds to the items on the column axis that represent the selected range. |
CustomSubtotalFunction | Returns the custom subtotal function field setting of a PivotCell object. |
DataField | Returns a PivotField object that corresponds to the selected data field. |
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. |
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. |
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. |