Method Details

• getRowItems

  IPivotItemList getRowItems()

  Returns a PivotItemList collection that corresponds to the items on the category axis that represent the selected cell.

• getColumnItems

  IPivotItemList getColumnItems()

  Returns a PivotItemList collection that corresponds to the items on the column axis that represent the selected range.

• getCustomSubtotalFunction

  ConsolidationFunction getCustomSubtotalFunction()

  Returns the custom subtotal function field setting of a PivotCell object.

• getDataField

  IPivotField getDataField()

  Returns a PivotField object that corresponds to the selected data field.

• getPivotCellType

  PivotCellType getPivotCellType()

  Returns a constant that identifies the PivotTable entity the cell corresponds to.

• getPivotColumnLine

  IPivotLine getPivotColumnLine()

  Returns the PivotLine on a column for a specific PivotCell object.

• getPivotField

  IPivotField getPivotField()

  Returns a PivotField object that represents the PivotTable field containing the upper-left corner of the specified range.

• getPivotItem

  IPivotItem getPivotItem()

  Returns a PivotItem object that represents the PivotTable item containing the upper-left corner of the specified range.

• getPivotRowLine

  IPivotLine getPivotRowLine()

  Returns the PivotLine on a row for a specific PivotCell object.

• getPivotTable

  IPivotTable getPivotTable()

  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.

• getRange

  IRange getRange()

  Returns a Range object that represents the range the specified PivotCell applies to.