Method Details

• getCount

  int getCount()

  Returns the number of objects in the collection.

• add

  IPivotTable add(IPivotCache PivotCache, IRange TableDestination)

  Adds a new PivotTable report.

  Parameters:

  PivotCache - The PivotTable cache on which the new PivotTable report is based.The cache provides data for the report.

  TableDestination - The cell in the upper-left corner of the PivotTable report'sdestination range (the range on the worksheet where the resulting report will be placed). You must specify a destination range on the worksheet that contains the PivotTables object specified by expression.

  Returns:

  PivotTable object

• add

  IPivotTable add(IPivotCache PivotCache, IRange TableDestination, String TableName)

  Adds a new PivotTable report.

  Parameters:

  PivotCache - The PivotTable cache on which the new PivotTable report is based.The cache provides data for the report.

  TableDestination - The cell in the upper-left corner of the PivotTable report'sdestination range (the range on the worksheet where the resulting report will be placed). You must specify a destination range on the worksheet that contains the PivotTables object specified by expression.

  TableName - The name of the new PivotTable report.

  Returns:

  PivotTable object

• get

  IPivotTable get(int index)

  Returns a single object from a collection.

  Parameters:

  index - The index number for the object.

• get

  IPivotTable get(String name)

  Returns a single object from a collection.

  Parameters:

  name - The name for the object.