Aspose::Cells::Pivot::PivotTableCollection::Add method
Contents
[
Hide
]PivotTableCollection::Add(const U16String&, const U16String&, const U16String&) method
Adds a new PivotTable.
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.
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.
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.
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.
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.
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.
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.
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 U16String&, int32_t, int32_t, const U16String&, bool, bool) method
Adds a new PivotTable.
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.
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. |
| 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. |
| 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++