Add

Add(string, string, string)

Adds a new PivotTable cache to a PivotCaches collection.

public int Add(string sourceData, string destCellName, string tableName)
Parameter Type Description
sourceData String The data cell range for the new PivotTable.Example : Sheet1!A1:C8
destCellName String The cell in the upper-left corner of the PivotTable report’s destination range.
tableName String The name of the new PivotTable report.

Return Value

The new added cache index.

See Also


Add(GridWorksheet, GridCellArea, string, string)

Adds a new PivotTable cache to a PivotCaches collection.

public int Add(GridWorksheet sourceSheet, GridCellArea sourceArea, string destCellName, 
    string tableName)
Parameter Description
sourceSheet The source work sheet.
sourceArea The area in the source worksheet.
destRow The row of the cell in the upper-left corner of the PivotTable report’s destination range.
destCol The column of the cell in the upper-left corner of the PivotTable report’s destination range.
tableName The name of the new PivotTable report.

Return Value

The new added cache index.

See Also


Add(string, GridCellArea, int, int, string)

Adds a new PivotTable cache to a PivotCaches collection.

public int Add(string worksheetname, GridCellArea sourceArea, int destRow, int destCol, 
    string tableName)
Parameter Type Description
worksheetname String The name of the source worksheet.
sourceArea GridCellArea The area in the source worksheet.
destRow Int32 The row of the cell in the upper-left corner of the PivotTable report’s destination range.
destCol Int32 The column of the cell in the upper-left corner of the PivotTable report’s destination range.
tableName String The name of the new PivotTable report.

Return Value

The new added cache index.

See Also


Add(string, GridCellArea, string, string)

Adds a new PivotTable cache to a PivotCaches collection.

public int Add(string worksheetname, GridCellArea sourceArea, string destCellName, string tableName)
Parameter Type Description
worksheetname String The name of the source worksheet.
sourceArea GridCellArea The area in the source worksheet.
destCellName String The cell in the upper-left corner of the PivotTable report’s destination range.
tableName String The name of the new PivotTable report.

Return Value

The new added cache index.

See Also