Document Solutions for Excel, Java Edition | Document Solutions
com.grapecity.documents.excel Package / IPivotTables Interface / add Method / add(IPivotCache,IRange) 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'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.
In This Topic
    add(IPivotCache,IRange) Method
    In This Topic
    Adds a new PivotTable report.
    Syntax
    IPivotTable add( 
   IPivotCache PivotCache,
   IRange TableDestination
)

    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.

    Return Value

    PivotTable object
    See Also

    Reference

    IPivotTables Interface
    IPivotTables Members
    Overload List