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):
    ...
ParameterTypeDescription
source_datastrThe data for the new PivotTable cache.
dest_cell_namestrThe cell in the upper-left corner of the PivotTable report’s destination range.
table_namestrThe 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):
    ...
ParameterTypeDescription
pivot_tablePivotTableThe source pivotTable.
dest_cell_namestrThe cell in the upper-left corner of the PivotTable report’s destination range.
table_namestrThe 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):
    ...
ParameterTypeDescription
source_datastrThe data for the new PivotTable cache.
dest_cell_namestrThe cell in the upper-left corner of the PivotTable report’s destination range.
table_namestrThe name of the new PivotTable report.
use_same_sourceboolIndicates 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):
    ...
ParameterTypeDescription
source_datastrThe data cell range for the new PivotTable.Example : Sheet1!A1:C8
rowintRow index of the cell in the upper-left corner of the PivotTable report’s destination range.
columnintColumn index of the cell in the upper-left corner of the PivotTable report’s destination range.
table_namestrThe 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):
    ...
ParameterTypeDescription
pivot_tablePivotTableThe source pivotTable.
rowintRow index of the cell in the upper-left corner of the PivotTable report’s destination range.
columnintColumn index of the cell in the upper-left corner of the PivotTable report’s destination range.
table_namestrThe 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):
    ...
ParameterTypeDescription
source_datastrThe data cell range for the new PivotTable.Example : Sheet1!A1:C8
rowintRow index of the cell in the upper-left corner of the PivotTable report’s destination range.
columnintColumn index of the cell in the upper-left corner of the PivotTable report’s destination range.
table_namestrThe name of the new PivotTable report.
use_same_sourceboolIndicates 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):
    ...
ParameterTypeDescription
source_datalistThe multiple consolidation ranges,such as {“Sheet1!A1:C8”,“Sheet2!A1:B8”}
is_auto_pageboolWhether auto create a single page field.
If true,the following param pageFields will be ignored.
page_fieldsPivotPageFieldsThe pivot page field items.
dest_cell_namestrdestCellName The name of the new PivotTable report.
table_namestrthe 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):
    ...
ParameterTypeDescription
source_datalistThe multiple consolidation ranges,such as {“Sheet1!A1:C8”,“Sheet2!A1:B8”}
is_auto_pageboolWhether auto create a single page field.
If true,the following param pageFields will be ignored
page_fieldsPivotPageFieldsThe pivot page field items.
rowintRow index of the cell in the upper-left corner of the PivotTable report’s destination range.
columnintColumn index of the cell in the upper-left corner of the PivotTable report’s destination range.
table_namestrThe name of the new PivotTable report.

See Also