Spire.XLS is a professional Excel API that enables developers to create, manage, manipulate, convert and print Excel worksheets. Get free and professional technical support for Spire.XLS for .NET, Java, Android, C++, Python.

Wed Nov 05, 2014 3:47 am

Dear mengting0917,

I have reproduced the issue you mentioned and posted it to our dev team, we will inform you if there is any update.
By the way, you can contact with my colleague daisy (daisy.zhang@e-iceblue.com) to see if she can give you some discount.

Best Regards,
Burning
E-iceblue Support Team
Best Regards,
Burning
E-iceblue Support Team
User avatar

burning.liu
 
Posts: 406
Joined: Mon Aug 04, 2014 6:47 am

Thu Nov 06, 2014 8:46 am

Dear mengting0917,

Please add code below in your project, then pivot table will update when you open it:
Code: Select all
//Change Row 7
//......
XlsPivotTable pt = workbook.Worksheets["Business Group Summary"].PivotTables["PivotTable1"] as XlsPivotTable;
pt.Cache.IsRefreshOnLoad = true;
//......

Best Regards,
Burning
E-iceblue Support Team
Best Regards,
Burning
E-iceblue Support Team
User avatar

burning.liu
 
Posts: 406
Joined: Mon Aug 04, 2014 6:47 am

Mon Nov 10, 2014 9:00 am

Dear mengting0917,

Have you tried the method I provided?
Please feel free to contact us if you have any problems.

Best Regards,
Burning
E-iceblue Support Team
Best Regards,
Burning
E-iceblue Support Team
User avatar

burning.liu
 
Posts: 406
Joined: Mon Aug 04, 2014 6:47 am

Return to Spire.XLS

cron