程序包 com.grapecity.documents.excel

接口 IPivotCell

public interface IPivotCell
Represents a cell in a PivotTable report.

  • 方法概要

    修饰符和类型
    方法
    说明
    IPivotItemList
    getColumnItems()
    Returns a PivotItemList collection that corresponds to the items on the column axis that represent the selected range.
    ConsolidationFunction
    getCustomSubtotalFunction()
    Returns the custom subtotal function field setting of a PivotCell object.
    IPivotField
    getDataField()
    Returns a PivotField object that corresponds to the selected data field.
    PivotCellType
    getPivotCellType()
    Returns a constant that identifies the PivotTable entity the cell corresponds to.
    IPivotLine
    getPivotColumnLine()
    Returns the PivotLine on a column for a specific PivotCell object.
    IPivotField
    getPivotField()
    Returns a PivotField object that represents the PivotTable field containing the upper-left corner of the specified range.
    IPivotItem
    getPivotItem()
    Returns a PivotItem object that represents the PivotTable item containing the upper-left corner of the specified range.
    IPivotLine
    getPivotRowLine()
    Returns the PivotLine on a row for a specific PivotCell object.
    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.
    IRange
    getRange()
    Returns a Range object that represents the range the specified PivotCell applies to.
    IPivotItemList
    getRowItems()
    Returns a PivotItemList collection that corresponds to the items on the category axis that represent the selected cell.

  • 方法详细资料

    • 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.