We are considering purchasing Aspose.Cells to fill an automation need. Our requirement is to take an existing XLSX file, which contains pivot tables and pivot charts pulling in data from an Analysis Services cube, and automatically refresh the pivot tables and charts pulling in the latest data, then save the result as PDF. Can Aspose.Cells do this?
Hi,
Yes, I think Aspose.Cells can serve your needs well. You can manipulate/update pivot tables and charts in the template file and refresh the pivot tables/charts and finally save to PDF document for your needs.
You need to call PivotTable.RefreshData() and PivotTable.CalculateData() just before saving the workbook to PDF document, e.g see the code segment below:
//…
//Your code goes here.
//…
pivotTable.RefreshData();
pivotTable.CalculateData();
workbook.Save(“C:\outDocument.pdf”, SaveFormat.Pdf);
Moreover, see some topics regarding PivotTables:
If you find any issue, let us know and we will help/sort out soon.
Thank you.