GridPivotTableCollection.Add

Add(string, string, string)

Adds a new PivotTable cache to a PivotCaches collection.

public int Add(string sourceData, string destCellName, string tableName)
ParameterTypeDescription
sourceDataStringThe data cell range for the new PivotTable.Example : Sheet1!A1:C8
destCellNameStringThe cell in the upper-left corner of the PivotTable report’s destination range.
tableNameStringThe name of the new PivotTable report.

Return Value

The new added cache index.

See Also


Add(Worksheet, GridCellArea, string, string)

Adds a new PivotTable cache to a PivotCaches collection.

public int Add(Worksheet sourceSheet, GridCellArea sourceArea, string destCellName, 
    string tableName)
ParameterDescription
sourceSheetThe source work sheet.
sourceAreaThe area in the source worksheet.
destRowThe row of the cell in the upper-left corner of the PivotTable report’s destination range.
destColThe column of the cell in the upper-left corner of the PivotTable report’s destination range.
tableNameThe 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)
ParameterTypeDescription
worksheetnameStringThe name of the source worksheet.
sourceAreaGridCellAreaThe area in the source worksheet.
destRowInt32The row of the cell in the upper-left corner of the PivotTable report’s destination range.
destColInt32The column of the cell in the upper-left corner of the PivotTable report’s destination range.
tableNameStringThe 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)
ParameterTypeDescription
worksheetnameStringThe name of the source worksheet.
sourceAreaGridCellAreaThe area in the source worksheet.
destCellNameStringThe cell in the upper-left corner of the PivotTable report’s destination range.
tableNameStringThe name of the new PivotTable report.

Return Value

The new added cache index.

See Also