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

• Open Markdown

• ---

• Open in ChatGPT
• Open in Claude
• Open in Perplexity

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

Adds a new PivotTable at the specified worksheet row and column position with default options.

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

Parameter	Type	Description
sourceData	const U16String&	The data cell range for the new PivotTable. Example: Sheet1!A1:C8
row	int32_t	The zero-based row index of the upper-left corner for the PivotTable destination.
column	int32_t	The zero-based column index of the upper-left corner for the PivotTable destination.

ReturnValue

The newly created PivotTable instance.

See Also

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

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

Adds a new PivotTable at the specified worksheet row and column position with default options.

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

Parameter	Type	Description
sourceData	const char16_t*	The data cell range for the new PivotTable. Example: Sheet1!A1:C8
row	int32_t	The zero-based row index of the upper-left corner for the PivotTable destination.
column	int32_t	The zero-based column index of the upper-left corner for the PivotTable destination.

ReturnValue

The newly created PivotTable instance.

See Also

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

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

Adds a new PivotTable with legacy Excel 97-2003 layout and style.

Deprecated

Use PivotTableCollection.Add(string, int, int, NewPivotTableOptions) overload instead. This method is equivalent to setting NewPivotTableOptions.IsXlsClassic = true.

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.

Remarks

NOTE: This method is obsolete. It is equivalent to calling PivotTableCollection.Add(string, int, int, NewPivotTableOptions) with NewPivotTableOptions.IsXlsClassic = true. Please use PivotTableCollection.Add(string, int, int, NewPivotTableOptions) overload instead. This method will be removed 12 months after September 2026. Apologies for any inconvenience.

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 with legacy Excel 97-2003 layout and style.

Deprecated

Use PivotTableCollection.Add(string, int, int, NewPivotTableOptions) overload instead. This method is equivalent to setting NewPivotTableOptions.IsXlsClassic = true.

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.

Remarks

NOTE: This method is obsolete. It is equivalent to calling PivotTableCollection.Add(string, int, int, NewPivotTableOptions) with NewPivotTableOptions.IsXlsClassic = true. Please use PivotTableCollection.Add(string, int, int, NewPivotTableOptions) overload instead. This method will be removed 12 months after September 2026. Apologies for any inconvenience.

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 with legacy Excel 97-2003 layout and style.

Deprecated

Use PivotTableCollection.Add(string, int, int, NewPivotTableOptions) overload instead. This method is equivalent to setting NewPivotTableOptions.IsXlsClassic = true.

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.

Remarks

NOTE: This method is obsolete. It is equivalent to calling PivotTableCollection.Add(string, int, int, NewPivotTableOptions) with NewPivotTableOptions.IsXlsClassic = true. Please use PivotTableCollection.Add(string, int, int, NewPivotTableOptions) overload instead. This method will be removed 12 months after September 2026. Apologies for any inconvenience.

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 with legacy Excel 97-2003 layout and style.

Deprecated

Use PivotTableCollection.Add(string, int, int, NewPivotTableOptions) overload instead. This method is equivalent to setting NewPivotTableOptions.IsXlsClassic = true.

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.

Remarks

NOTE: This method is obsolete. It is equivalent to calling PivotTableCollection.Add(string, int, int, NewPivotTableOptions) with NewPivotTableOptions.IsXlsClassic = true. Please use PivotTableCollection.Add(string, int, int, NewPivotTableOptions) overload instead. This method will be removed 12 months after September 2026. Apologies for any inconvenience.

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 with legacy Excel 97-2003 layout and style.

Deprecated

Use PivotTableCollection.Add(string, int, int, NewPivotTableOptions) overload instead. This method is equivalent to setting NewPivotTableOptions.IsXlsClassic = true.

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.

Remarks

NOTE: This method is obsolete. It is equivalent to calling PivotTableCollection.Add(string, int, int, NewPivotTableOptions) with NewPivotTableOptions.IsXlsClassic = true. Please use PivotTableCollection.Add(string, int, int, NewPivotTableOptions) overload instead. This method will be removed 12 months after September 2026. Apologies for any inconvenience.

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 with legacy Excel 97-2003 layout and style.

Deprecated

Use PivotTableCollection.Add(string, int, int, NewPivotTableOptions) overload instead. This method is equivalent to setting NewPivotTableOptions.IsXlsClassic = true.

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.

Remarks

NOTE: This method is obsolete. It is equivalent to calling PivotTableCollection.Add(string, int, int, NewPivotTableOptions) with NewPivotTableOptions.IsXlsClassic = true. Please use PivotTableCollection.Add(string, int, int, NewPivotTableOptions) overload instead. This method will be removed 12 months after September 2026. Apologies for any inconvenience.

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 with legacy Excel 97-2003 layout and style.

Deprecated

Use PivotTableCollection.Add(string, int, int, NewPivotTableOptions) overload instead. This method is equivalent to setting NewPivotTableOptions.IsXlsClassic = true.

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.

Remarks

NOTE: This method is obsolete. It is equivalent to calling PivotTableCollection.Add(string, int, int, NewPivotTableOptions) with NewPivotTableOptions.IsXlsClassic = true. Please use PivotTableCollection.Add(string, int, int, NewPivotTableOptions) overload instead. This method will be removed 12 months after September 2026. Apologies for any inconvenience.

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 with legacy Excel 97-2003 layout and style.

Deprecated

Use PivotTableCollection.Add(string, int, int, NewPivotTableOptions) overload instead. This method is equivalent to setting NewPivotTableOptions.IsXlsClassic = true.

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.

Remarks

NOTE: This method is obsolete. It is equivalent to calling PivotTableCollection.Add(string, int, int, NewPivotTableOptions) with NewPivotTableOptions.IsXlsClassic = true. Please use PivotTableCollection.Add(string, int, int, NewPivotTableOptions) overload instead. This method will be removed 12 months after September 2026. Apologies for any inconvenience.

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, bool) method

Adds a new PivotTable with legacy Excel 97-2003 layout and style.

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

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.
isXlsClassic	bool	Indicates whether add classic pivot table of Excel 97-2003.

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, bool) method

Adds a new PivotTable with legacy Excel 97-2003 layout and style.

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

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.
isXlsClassic	bool	Indicates whether add classic pivot table of Excel 97-2003.

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, bool) method

Adds a new PivotTable.

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

Parameter	Type	Description
sourceData	const U16String&	The data cell range for the new PivotTable.Example : Sheet1!A1:C8
cell	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 when same data source has been gathered into one pivot cache.
isXlsClassic	bool	Indicates whether add classic pivot table of Excel 97-2003.

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, bool) method

Adds a new PivotTable.

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

Parameter	Type	Description
sourceData	const char16_t*	The data cell range for the new PivotTable.Example : Sheet1!A1:C8
cell	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 when same data source has been gathered into one pivot cache.
isXlsClassic	bool	Indicates whether add classic pivot table of Excel 97-2003.

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 based on 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 based on 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 based on 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 based on 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 PivotTableObject 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 PivotTableObject 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 PivotTableObject 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 PivotTableObject 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++