PivotTableCollectionAdd Method (String, Int32, Int32, String, Boolean)

Adds a new PivotTable cache to a PivotCaches collection.

Namespace:  Aspose.Cells.Pivot
Assembly:  Aspose.Cells (in Aspose.Cells.dll) Version: 20.9.0.0 (20.9)
Syntax
public int Add(
	string sourceData,
	int row,
	int column,
	string tableName,
	bool useSameSource
)

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.
useSameSource
Type: SystemBoolean
Indicates whether using same data source when another existing pivot table has used this data source. If the property is true, it will save memory.

Return Value

Type: Int32
The new added cache index.
See Also