Refresh of Pivot table after change of Report Filter

Aspose.Cells Product Family
1

Hi,

Is there a way we can refresh the data in the pivot table after changing the report filter using aspose.cells.

I don't see any refresh method.

Thanks,

2

Hi,

Well, I am afraid there is no such feature available at the moment. The component does not support to manipulate the Pivot Tables in the template files. Aspose.Cells creates/formulates pivot data only and it forces MS Excel to create a pivot table when opening the file into MS Excel. It actually implements the refresh on open option/setting for MS Excel, so, when you open the generated file(by Aspose.Cells) into MS Excel, the pivot table is then created.

Just to update you further, we are currently working on reading pivot tables in template files, hopefully the feature would be completed in Q1 2010.

Thank you.

3

Hello, is this feature available now with the last release?

4

Hi,

We have already logged it (into our issue tracking system) with an id: CELLSNET-4661

The issue is under process still.

We will check if we can provide you an eta for the feature soon.

Thank you.