calculate_data method
Contents
[
Hide
]calculate_data(self)
Calculates data of pivottable to cells.
def calculate_data(self):
...
Remarks
This method only calculate data with the cached data in the PivotTable.pivot_cache.
So if you want to calcualte with latest data source, please use PivotCache.refresh method to calculate.
If only the setting of pivot table is changed, PivotTable.calculate_data is enough.
calculate_data(self, option)
Calculates pivot table with options.
Returns
Returns all pivot tables which have been calculated.
If PivotTableCalculateOption.refresh_data is true,all pivot tables based on same pivot cache will be calculated together.
def calculate_data(self, option):
...
| Parameter | Type | Description |
|---|---|---|
| option | aspose.cells.pivot.PivotTableCalculateOption | The options for calculating the pivot table |
Remarks
If PivotTableCalculateOption.refresh_data is true,
this method will refresh pivot cache from data source,then calculate all pivot tables based same pivot cache.
Otherwise, only calculating with the cached data in the pivot cache.
See Also
- module
aspose.cells.pivot - class
PivotTable