Refresh PivotTables and Charts in Excel in C#

[oumaima111]

I have an Excel file with PivotTables and Charts and I want them to be refreshed automatically!
My program takes an Excel with 5 sheets and returns a pdf file (i use Spire.Pdf to convert/print the file). I have 2 sheets X and Y: X contains Data, Y: contains PivotTables and Charts to be refreshed with the data of sheet X and I couldn't any solution to refresh those charts but it works fine with PivotTables. Any solution, please? Or maybe refresh all the sheet?

[Triste.Dai]

Hi，

Thanks for your inquiry.
To help us work out a solution for you, could you please provide us with the following messages? You can send them to us via email (support@e-iceblue.com) or attach them here. Thanks for your assistance in advance.
1) your full code and sample file.
2) the version of Spire.Xls in your project.

Sincerely,
Triste
E-iceblue support team

[oumaima111]

I sent the email !

[Triste.Dai]

Hi,

Thanks for your feedback.
I tested your xlsx file with Spire.XLS(12.12.3), using the following code,

Code: Select all

 
            Workbook workbook = new Workbook();
            workbook.ConverterSetting.ClearCacheOnConverted= true;
            workbook.LoadFromFile("TEST tcd & charts MODELARIO2.xlsx");
            var pt = workbook.Worksheets["TEST TCD"].PivotTables;
            foreach (Spire.Xls.Core.Spreadsheet.PivotTables.XlsPivotTable item in pt)
            {
                item.Cache.IsRefreshOnLoad = true;
                item.CalculateData();
            }

            var tables = workbook.Worksheets["TEST TCD"].Charts;
            foreach (Chart chart in tables)
            {
                chart.RefreshChart();
            }
            workbook.SaveToFile("output.pdf", FileFormat.PDF);

the PivotTables and charts are refreshed, but I found a mistake, the labels and shapes are not aligned, see attached.

Picture1.png (19.97 KiB) Viewed 2504 times

I have logged this issue into our bug tracking system with the ticket number SPIREXLS-4402, Our developers will investigate and fix it, sorry for the inconvenience caused. Once the issue is fixed, I will inform you in time.

Sincerely,
Triste
E-iceblue support team

[Triste.Dai]

Hi,

Thanks for your patience!
Glad to inform you that we just released Spire.XLS 13.2.4 which fixes the issue with SPIREXLS-4402.
Please download the new version from the following links to test.
Website download link: https://www.e-iceblue.com/Download/download-excel-for-net-now.html
Nuget download link: https://www.nuget.org/packages/Spire.XLS/13.2.4

Sincerely,
Triste
E-iceblue support team