PivotTableCollectionAdd Method (String, Int32, Int32, String)

Adds a new PivotTable cache to a PivotCaches collection.

Namespace:  Aspose.Cells.Pivot
Assembly:  Aspose.Cells (in Aspose.Cells.dll) Version: 21.5.0.0 (21.5)
Syntax
public int Add(
	string sourceData,
	int row,
	int column,
	string tableName
)

Parameters

sourceData
Type: SystemString
The data cell range for the new PivotTable.Example : Sheet1!A1:C8
row
Type: SystemInt32
Row index of the cell in the upper-left corner of the PivotTable report's destination range.
column
Type: SystemInt32
Column index of the cell in the upper-left corner of the PivotTable report's destination range.
tableName
Type: SystemString
The name of the new PivotTable report.

Return Value

Type: Int32
The new added cache index.
See Also