add(IPivotCache,IRange,String) Method

In This Topic

Adds a new PivotTable report.

Syntax

IPivotTable add( 
   IPivotCache PivotCache,
   IRange TableDestination,
   java.lang.String TableName
)

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.

PivotTable object