程序包 com.grapecity.documents.excel

接口 IPivotCache

public interface IPivotCache
Represents the memory cache for a PivotTable report.

  • 方法详细资料

    • getIndex

      int getIndex()
      Returns the index number of the object within the collection of similar objects.

    • getRecordCount

      int getRecordCount()
      Returns the number of records in the PivotTable cache or the number of cache records that contain the specified item.

    • getRefreshDate

      @Deprecated Date getRefreshDate()
      已过时。

      This member is obsolete. Use getRefreshLocalDateTime() instead.

      Returns the date on which the PivotTable cache was last refreshed.

    • getRefreshLocalDateTime

      LocalDateTime getRefreshLocalDateTime()
      Returns the date on which the PivotTable cache was last refreshed.

    • getRefreshName

      String getRefreshName()
      Returns the name of the person who last refreshed the PivotTable cache.

    • getSourceData

      IRange getSourceData()
      Gets the data source for the PivotTable report.

    • setSourceData

      void setSourceData(IRange value)
      Sets the data source for the PivotTable report.

    • createPivotTable

      IPivotTable createPivotTable(IRange TableDestination)
      Creates a PivotTable report based on a PivotCache object.
      参数:
      TableDestination - The cell in the upper-left corner of the PivotTable report’sdestination range (the range on the worksheet where the resulting PivotTable report will be placed). The destination range must be on a worksheet in the workbook that contains the PivotCache object specified by expression.

    • createPivotTable

      IPivotTable createPivotTable(IRange TableDestination, String TableName)
      Creates a PivotTable report based on a PivotCache object.
      参数:
      TableDestination - The cell in the upper-left corner of the PivotTable report’sdestination range (the range on the worksheet where the resulting PivotTable report will be placed). The destination range must be on a worksheet in the workbook that contains the PivotCache object specified by expression.
      TableName - The name of the new PivotTable report.

    • refresh

      void refresh()
      Updates the cache of the PivotTable object.