[]
Adds a new PivotTable report.
IPivotTable Add(IPivotCache PivotCache, IRange TableDestination, string TableName = null)
| Type | Name | Description |
|---|---|---|
| IPivotCache | PivotCache | The PivotTable cache on which the new PivotTable report is based. The cache provides data for the report. |
| IRange | TableDestination | The cell in the upper-left corner of the PivotTable report's destination 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. |
| string | TableName | The name of the new PivotTable report. |
| Type | Description |
|---|---|
| IPivotTable | PivotTable object. |