Aspose::Cells::Pivot::PivotTableCollection::Add method

PivotTableCollection::Add(const U16String&, const U16String&, const U16String&) method

Adds a new PivotTable cache to a PivotCaches collection.

int32_t Aspose::Cells::Pivot::PivotTableCollection::Add(const U16String &sourceData, const U16String &destCellName, const U16String &tableName)

Parameter	Type	Description
sourceData	const U16String&	The data for the new PivotTable cache.
destCellName	const U16String&	The cell in the upper-left corner of the PivotTable report’s destination range.
tableName	const U16String&	The name of the new PivotTable report.

ReturnValue

The new added cache index.

See Also

• Class Vector
• Class U16String
• Class PivotTableCollection
• Namespace Aspose::Cells::Pivot
• Library Aspose.Cells for C++

PivotTableCollection::Add(const char16_t*, const char16_t*, const char16_t*) method

Adds a new PivotTable cache to a PivotCaches collection.

int32_t Aspose::Cells::Pivot::PivotTableCollection::Add(const char16_t *sourceData, const char16_t *destCellName, const char16_t *tableName)

Parameter	Type	Description
sourceData	const char16_t*	The data for the new PivotTable cache.
destCellName	const char16_t*	The cell in the upper-left corner of the PivotTable report’s destination range.
tableName	const char16_t*	The name of the new PivotTable report.

ReturnValue

The new added cache index.

See Also

• Class Vector
• Class PivotTableCollection
• Namespace Aspose::Cells::Pivot
• Library Aspose.Cells for C++

PivotTableCollection::Add(const U16String&, const U16String&, const U16String&, bool) method

Adds a new PivotTable cache to a PivotCaches collection.

int32_t Aspose::Cells::Pivot::PivotTableCollection::Add(const U16String &sourceData, const U16String &destCellName, const U16String &tableName, bool useSameSource)

Parameter	Type	Description
sourceData	const U16String&	The data for the new PivotTable cache.
destCellName	const U16String&	The cell in the upper-left corner of the PivotTable report’s destination range.
tableName	const U16String&	The name of the new PivotTable report.
useSameSource	bool	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.

ReturnValue

The new added cache index.

See Also

• Class Vector
• Class U16String
• Class PivotTableCollection
• Namespace Aspose::Cells::Pivot
• Library Aspose.Cells for C++

PivotTableCollection::Add(const char16_t*, const char16_t*, const char16_t*, bool) method

Adds a new PivotTable cache to a PivotCaches collection.

int32_t Aspose::Cells::Pivot::PivotTableCollection::Add(const char16_t *sourceData, const char16_t *destCellName, const char16_t *tableName, bool useSameSource)

Parameter	Type	Description
sourceData	const char16_t*	The data for the new PivotTable cache.
destCellName	const char16_t*	The cell in the upper-left corner of the PivotTable report’s destination range.
tableName	const char16_t*	The name of the new PivotTable report.
useSameSource	bool	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.

ReturnValue

The new added cache index.

See Also

• Class Vector
• Class PivotTableCollection
• Namespace Aspose::Cells::Pivot
• Library Aspose.Cells for C++

PivotTableCollection::Add(const U16String&, int32_t, int32_t, const U16String&) method

Adds a new PivotTable cache to a PivotCaches collection.

int32_t Aspose::Cells::Pivot::PivotTableCollection::Add(const U16String &sourceData, int32_t row, int32_t column, const U16String &tableName)

Parameter	Type	Description
sourceData	const U16String&	The data cell range for the new PivotTable.Example : Sheet1!A1:C8
row	int32_t	Row index of the cell in the upper-left corner of the PivotTable report’s destination range.
column	int32_t	Column index of the cell in the upper-left corner of the PivotTable report’s destination range.
tableName	const U16String&	The name of the new PivotTable report.

ReturnValue

The new added cache index.

See Also

• Class Vector
• Class U16String
• Class PivotTableCollection
• Namespace Aspose::Cells::Pivot
• Library Aspose.Cells for C++

PivotTableCollection::Add(const char16_t*, int32_t, int32_t, const char16_t*) method

Adds a new PivotTable cache to a PivotCaches collection.

int32_t Aspose::Cells::Pivot::PivotTableCollection::Add(const char16_t *sourceData, int32_t row, int32_t column, const char16_t *tableName)

Parameter	Type	Description
sourceData	const char16_t*	The data cell range for the new PivotTable.Example : Sheet1!A1:C8
row	int32_t	Row index of the cell in the upper-left corner of the PivotTable report’s destination range.
column	int32_t	Column index of the cell in the upper-left corner of the PivotTable report’s destination range.
tableName	const char16_t*	The name of the new PivotTable report.

ReturnValue

The new added cache index.

See Also

• Class Vector
• Class PivotTableCollection
• Namespace Aspose::Cells::Pivot
• Library Aspose.Cells for C++

PivotTableCollection::Add(const U16String&, int32_t, int32_t, const U16String&, bool) method

Adds a new PivotTable cache to a PivotCaches collection.

int32_t Aspose::Cells::Pivot::PivotTableCollection::Add(const U16String &sourceData, int32_t row, int32_t column, const U16String &tableName, bool useSameSource)

Parameter	Type	Description
sourceData	const U16String&	The data cell range for the new PivotTable.Example : Sheet1!A1:C8
row	int32_t	Row index of the cell in the upper-left corner of the PivotTable report’s destination range.
column	int32_t	Column index of the cell in the upper-left corner of the PivotTable report’s destination range.
tableName	const U16String&	The name of the new PivotTable report.
useSameSource	bool	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.

ReturnValue

The new added cache index.

See Also

• Class Vector
• Class U16String
• Class PivotTableCollection
• Namespace Aspose::Cells::Pivot
• Library Aspose.Cells for C++

PivotTableCollection::Add(const char16_t*, int32_t, int32_t, const char16_t*, bool) method

Adds a new PivotTable cache to a PivotCaches collection.

int32_t Aspose::Cells::Pivot::PivotTableCollection::Add(const char16_t *sourceData, int32_t row, int32_t column, const char16_t *tableName, bool useSameSource)

Parameter	Type	Description
sourceData	const char16_t*	The data cell range for the new PivotTable.Example : Sheet1!A1:C8
row	int32_t	Row index of the cell in the upper-left corner of the PivotTable report’s destination range.
column	int32_t	Column index of the cell in the upper-left corner of the PivotTable report’s destination range.
tableName	const char16_t*	The name of the new PivotTable report.
useSameSource	bool	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.

ReturnValue

The new added cache index.

See Also

• Class Vector
• Class PivotTableCollection
• Namespace Aspose::Cells::Pivot
• Library Aspose.Cells for C++

PivotTableCollection::Add(const PivotTable&, const U16String&, const U16String&) method

Adds a new PivotTable Object to the collection from another PivotTable.

int32_t Aspose::Cells::Pivot::PivotTableCollection::Add(const PivotTable &pivotTable, const U16String &destCellName, const U16String &tableName)

Parameter	Type	Description
pivotTable	const PivotTable&	The source pivotTable.
destCellName	const U16String&	The cell in the upper-left corner of the PivotTable report’s destination range.
tableName	const U16String&	The name of the new PivotTable report.

ReturnValue

The new added PivotTable index.

See Also

• Class Vector
• Class PivotTable
• Class U16String
• Class PivotTableCollection
• Namespace Aspose::Cells::Pivot
• Library Aspose.Cells for C++

PivotTableCollection::Add(const PivotTable&, const char16_t*, const char16_t*) method

Adds a new PivotTable Object to the collection from another PivotTable.

int32_t Aspose::Cells::Pivot::PivotTableCollection::Add(const PivotTable &pivotTable, const char16_t *destCellName, const char16_t *tableName)

Parameter	Type	Description
pivotTable	const PivotTable&	The source pivotTable.
destCellName	const char16_t*	The cell in the upper-left corner of the PivotTable report’s destination range.
tableName	const char16_t*	The name of the new PivotTable report.

ReturnValue

The new added PivotTable index.

See Also

• Class Vector
• Class PivotTable
• Class PivotTableCollection
• Namespace Aspose::Cells::Pivot
• Library Aspose.Cells for C++

PivotTableCollection::Add(const PivotTable&, int32_t, int32_t, const U16String&) method

Adds a new PivotTable Object to the collection from another PivotTable.

int32_t Aspose::Cells::Pivot::PivotTableCollection::Add(const PivotTable &pivotTable, int32_t row, int32_t column, const U16String &tableName)

Parameter	Type	Description
pivotTable	const PivotTable&	The source pivotTable.
row	int32_t	Row index of the cell in the upper-left corner of the PivotTable report’s destination range.
column	int32_t	Column index of the cell in the upper-left corner of the PivotTable report’s destination range.
tableName	const U16String&	The name of the new PivotTable report.

ReturnValue

The new added PivotTable index.

See Also

• Class Vector
• Class PivotTable
• Class U16String
• Class PivotTableCollection
• Namespace Aspose::Cells::Pivot
• Library Aspose.Cells for C++

PivotTableCollection::Add(const PivotTable&, int32_t, int32_t, const char16_t*) method

Adds a new PivotTable Object to the collection from another PivotTable.

int32_t Aspose::Cells::Pivot::PivotTableCollection::Add(const PivotTable &pivotTable, int32_t row, int32_t column, const char16_t *tableName)

Parameter	Type	Description
pivotTable	const PivotTable&	The source pivotTable.
row	int32_t	Row index of the cell in the upper-left corner of the PivotTable report’s destination range.
column	int32_t	Column index of the cell in the upper-left corner of the PivotTable report’s destination range.
tableName	const char16_t*	The name of the new PivotTable report.

ReturnValue

The new added PivotTable index.

See Also

• Class Vector
• Class PivotTable
• Class PivotTableCollection
• Namespace Aspose::Cells::Pivot
• Library Aspose.Cells for C++

PivotTableCollection::Add(const Vector <U16String>&, bool, const PivotPageFields&, const U16String&, const U16String&) method

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

int32_t Aspose::Cells::Pivot::PivotTableCollection::Add(const Vector<U16String> &sourceData, bool isAutoPage, const PivotPageFields &pageFields, const U16String &destCellName, const U16String &tableName)

Parameter	Type	Description
sourceData	const Vector <U16String>&	The multiple consolidation ranges,such as {“Sheet1!A1:C8”,“Sheet2!A1:B8”}
isAutoPage	bool	Whether auto create a single page field. If true,the following param pageFields will be ignored.
pageFields	const PivotPageFields&	The pivot page field items.
destCellName	const U16String&	destCellName The name of the new PivotTable report.
tableName	const U16String&	the name of the new PivotTable report.

ReturnValue

The new added PivotTable index.

See Also

• Class Vector
• Class U16String
• Class PivotPageFields
• Class PivotTableCollection
• Namespace Aspose::Cells::Pivot
• Library Aspose.Cells for C++

PivotTableCollection::Add(const Vector <U16String>&, bool, const PivotPageFields&, const char16_t*, const char16_t*) method

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

int32_t Aspose::Cells::Pivot::PivotTableCollection::Add(const Vector<U16String> &sourceData, bool isAutoPage, const PivotPageFields &pageFields, const char16_t *destCellName, const char16_t *tableName)

Parameter	Type	Description
sourceData	const Vector <U16String>&	The multiple consolidation ranges,such as {“Sheet1!A1:C8”,“Sheet2!A1:B8”}
isAutoPage	bool	Whether auto create a single page field. If true,the following param pageFields will be ignored.
pageFields	const PivotPageFields&	The pivot page field items.
destCellName	const char16_t*	destCellName The name of the new PivotTable report.
tableName	const char16_t*	the name of the new PivotTable report.

ReturnValue

The new added PivotTable index.

See Also

• Class Vector
• Class U16String
• Class PivotPageFields
• Class PivotTableCollection
• Namespace Aspose::Cells::Pivot
• Library Aspose.Cells for C++

PivotTableCollection::Add(const Vector <U16String>&, bool, const PivotPageFields&, int32_t, int32_t, const U16String&) method

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

int32_t Aspose::Cells::Pivot::PivotTableCollection::Add(const Vector<U16String> &sourceData, bool isAutoPage, const PivotPageFields &pageFields, int32_t row, int32_t column, const U16String &tableName)

Parameter	Type	Description
sourceData	const Vector <U16String>&	The multiple consolidation ranges,such as {“Sheet1!A1:C8”,“Sheet2!A1:B8”}
isAutoPage	bool	Whether auto create a single page field. If true,the following param pageFields will be ignored
pageFields	const PivotPageFields&	The pivot page field items.
row	int32_t	Row index of the cell in the upper-left corner of the PivotTable report’s destination range.
column	int32_t	Column index of the cell in the upper-left corner of the PivotTable report’s destination range.
tableName	const U16String&	The name of the new PivotTable report.

ReturnValue

The new added PivotTable index.

See Also

• Class Vector
• Class U16String
• Class PivotPageFields
• Class PivotTableCollection
• Namespace Aspose::Cells::Pivot
• Library Aspose.Cells for C++

PivotTableCollection::Add(const Vector <U16String>&, bool, const PivotPageFields&, int32_t, int32_t, const char16_t*) method

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

int32_t Aspose::Cells::Pivot::PivotTableCollection::Add(const Vector<U16String> &sourceData, bool isAutoPage, const PivotPageFields &pageFields, int32_t row, int32_t column, const char16_t *tableName)

Parameter	Type	Description
sourceData	const Vector <U16String>&	The multiple consolidation ranges,such as {“Sheet1!A1:C8”,“Sheet2!A1:B8”}
isAutoPage	bool	Whether auto create a single page field. If true,the following param pageFields will be ignored
pageFields	const PivotPageFields&	The pivot page field items.
row	int32_t	Row index of the cell in the upper-left corner of the PivotTable report’s destination range.
column	int32_t	Column index of the cell in the upper-left corner of the PivotTable report’s destination range.
tableName	const char16_t*	The name of the new PivotTable report.

ReturnValue

The new added PivotTable index.

See Also

• Class Vector
• Class U16String
• Class PivotPageFields
• Class PivotTableCollection
• Namespace Aspose::Cells::Pivot
• Library Aspose.Cells for C++