Document Solutions for Excel, .NET Edition | Document Solutions
GrapeCity.Documents.Excel Namespace / IPivotTables Interface / Add Method
The PivotTable cache on which the new PivotTable report is based. The cache provides data for the report.
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.
The name of the new PivotTable report.
In This Topic
    Add Method (IPivotTables)
    In This Topic
    Adds a new PivotTable report.
    Syntax
    IPivotTable Add( 
   IPivotCache PivotCache,
   IRange TableDestination,
   System.string TableName
)

    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'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.
    TableName
    The name of the new PivotTable report.

    Return Value

    PivotTable object
    See Also

    Reference

    IPivotTables Interface
    IPivotTables Members