[]
Represents a cell in a PivotTable report.
public interface IPivotCell
Returns a PivotItemList collection that corresponds to the items on the column axis that represent the selected range.
IPivotItemList ColumnItems { get; }
Returns the custom subtotal function field setting of a PivotCell object.
ConsolidationFunction CustomSubtotalFunction { get; }
Returns a PivotField object that corresponds to the selected data field.
IPivotField DataField { get; }
Returns a constant that identifies the PivotTable entity the cell corresponds to.
PivotCellType PivotCellType { get; }
Returns the PivotLine on a column for a specific PivotCell object.
IPivotLine PivotColumnLine { get; }
Returns a PivotField object that represents the PivotTable field containing the upper-left corner of the specified range.
IPivotField PivotField { get; }
Returns a PivotItem object that represents the PivotTable item containing the upper-left corner of the specified range.
IPivotItem PivotItem { get; }
Returns the PivotLine on a row for a specific PivotCell object.
IPivotLine PivotRowLine { get; }
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.
IPivotTable PivotTable { get; }
Returns a Range object that represents the range the specified PivotCell applies to.
IRange Range { get; }
Returns a PivotItemList collection that corresponds to the items on the category axis that represent the selected cell.
IPivotItemList RowItems { get; }