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

Adds a new PivotTable Object to the collection with multiple consolidation ranges as data source.

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

Parameters

sourceData
Type: SystemString
The multiple consolidation ranges,such as {"Sheet1!A1:C8","Sheet2!A1:B8"}
isAutoPage
Type: SystemBoolean
Whether auto create a single page field. If true,the following param pageFields will be ignored
pageFields
Type: Aspose.Cells.PivotPivotPageFields
The pivot page field items.
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 PivotTable index.
See Also