add method
add
Adds a new PivotTable cache to a PivotCaches collection.
Returns
The new added cache index.
def add(self, source_data, dest_cell_name, table_name):
...
Parameter | Type | Description |
---|---|---|
source_data | str | The data for the new PivotTable cache. |
dest_cell_name | str | The cell in the upper-left corner of the PivotTable report’s destination range. |
table_name | str | The name of the new PivotTable report. |
add
Adds a new PivotTable Object to the collection from another PivotTable.
Returns
The new added PivotTable index.
def add(self, pivot_table, dest_cell_name, table_name):
...
Parameter | Type | Description |
---|---|---|
pivot_table | PivotTable | The source pivotTable. |
dest_cell_name | str | The cell in the upper-left corner of the PivotTable report’s destination range. |
table_name | str | The name of the new PivotTable report. |
add
Adds a new PivotTable cache to a PivotCaches collection.
Returns
The new added cache index.
def add(self, source_data, dest_cell_name, table_name, use_same_source):
...
Parameter | Type | Description |
---|---|---|
source_data | str | The data for the new PivotTable cache. |
dest_cell_name | str | The cell in the upper-left corner of the PivotTable report’s destination range. |
table_name | str | The name of the new PivotTable report. |
use_same_source | 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. |
add
Adds a new PivotTable cache to a PivotCaches collection.
Returns
The new added cache index.
def add(self, source_data, row, column, table_name):
...
Parameter | Type | Description |
---|---|---|
source_data | str | The data cell range for the new PivotTable.Example : Sheet1!A1:C8 |
row | int | Row index of the cell in the upper-left corner of the PivotTable report’s destination range. |
column | int | Column index of the cell in the upper-left corner of the PivotTable report’s destination range. |
table_name | str | The name of the new PivotTable report. |
add
Adds a new PivotTable Object to the collection from another PivotTable.
Returns
The new added PivotTable index.
def add(self, pivot_table, row, column, table_name):
...
Parameter | Type | Description |
---|---|---|
pivot_table | PivotTable | The source pivotTable. |
row | int | Row index of the cell in the upper-left corner of the PivotTable report’s destination range. |
column | int | Column index of the cell in the upper-left corner of the PivotTable report’s destination range. |
table_name | str | The name of the new PivotTable report. |
add
Adds a new PivotTable cache to a PivotCaches collection.
Returns
The new added cache index.
def add(self, source_data, row, column, table_name, use_same_source):
...
Parameter | Type | Description |
---|---|---|
source_data | str | The data cell range for the new PivotTable.Example : Sheet1!A1:C8 |
row | int | Row index of the cell in the upper-left corner of the PivotTable report’s destination range. |
column | int | Column index of the cell in the upper-left corner of the PivotTable report’s destination range. |
table_name | str | The name of the new PivotTable report. |
use_same_source | 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. |
add
Adds a new PivotTable Object to the collection with multiple consolidation ranges as data source.
Returns
The new added PivotTable index.
def add(self, source_data, is_auto_page, page_fields, dest_cell_name, table_name):
...
Parameter | Type | Description |
---|---|---|
source_data | list | The multiple consolidation ranges,such as {“Sheet1!A1:C8”,“Sheet2!A1:B8”} |
is_auto_page | bool | Whether auto create a single page field. If true,the following param pageFields will be ignored. |
page_fields | PivotPageFields | The pivot page field items. |
dest_cell_name | str | destCellName The name of the new PivotTable report. |
table_name | str | the name of the new PivotTable report. |
add
Adds a new PivotTable Object to the collection with multiple consolidation ranges as data source.
Returns
The new added PivotTable index.
def add(self, source_data, is_auto_page, page_fields, row, column, table_name):
...
Parameter | Type | Description |
---|---|---|
source_data | list | The multiple consolidation ranges,such as {“Sheet1!A1:C8”,“Sheet2!A1:B8”} |
is_auto_page | bool | Whether auto create a single page field. If true,the following param pageFields will be ignored |
page_fields | PivotPageFields | The pivot page field items. |
row | int | Row index of the cell in the upper-left corner of the PivotTable report’s destination range. |
column | int | Column index of the cell in the upper-left corner of the PivotTable report’s destination range. |
table_name | str | The name of the new PivotTable report. |
See Also
- module
aspose.cells.pivot
- class
PivotTableCollection