Free Support Forum - aspose.com

Pivot Table/Chart

Where is the API to references to manipulate the properties of a Pivote Table in Aspose.Excel (v1.8.7.1)? I can’t find any Property/Method on the Worksheet object. I did a search on the Object Browser but nothing found.

Can we do Pivot Table/Chart through Aspose.Excel?

Thanks,
Prodip

Hi Prodip,

Currently Aspose.Excel supports the pivot table/chart in designer. You can create pivot table/chart in your designer file and use Aspose.Excel to import it. And you can change the data source of pivot table/chart at run time.

We are thinking of provide pivot table APIs. But it may take for about several months.

Laurence,
Thanks for the reply.

All we have is the dll. What do you mean by the designer? And, how do I change the data source to the Pivot table at run time?

As an alternate method, I am thinking to create an excel template file with a Pivot table and chart. I rewrite the data through aspose excel but I need the API to change Pivot table configurations. Is it possible to change the data source of the Pivot table though aspose API?

Thanks,
Prodip

Hi Prodip,

We call the template file as a designer spreadsheet because you can design the content and style of your report manually.

Your understanding is correct and your method is feasible. You can use Aspose.Excel to rewrite the data but not the configuration. Please have a try.

Hi Laurence,
I have created a designer(xls template) file with a Pivot Table, Pivote Chart and Pivot Data Source with some static data. The problem is–I could not find how to refresh data (i.e. change the reference range) for the Pivot Table.

Could you please shed some lights?

Thanks,
Prodip

Hi Prodip,

Could you send your designer file to me?

Generally you can set the data source of the static data on a range of cell. Please remember to set “Refresh on open” in “Table Options”.

Then you can use Aspose.Excel to change the data on these cells during run time. The data will be refreshed when you open the result file.