PivotTableCollectionAdd Method (String, Boolean, PivotPageFields, String, 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.6.0.0 (21.6)
Syntax
public int Add(
	string[] sourceData,
	bool isAutoPage,
	PivotPageFields pageFields,
	string destCellName,
	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.
destCellName
Type: SystemString
destCellName The name of the new PivotTable report.
tableName
Type: SystemString
the name of the new PivotTable report.

Return Value

Type: Int32
The new added PivotTable index.
See Also