Getting error while trying to export large pivot view to excel

[Muhammad Waqas]

Hello Syncfusion Team

I am facing error while trying to export pivot view with large data for reference I have attached a test project

https://drive.google.com/file/d/1entxPL-kiivWQG9BqEJ-A4f-1-qAw7HP/view?usp=sharing

Regards

Muhammad Waqas Aziz

[Manikandan Murugesan]

Hi Muhammad, 

Currently we are analyzing the problem at our end, and we will update further details within two business days (January 12, 2021). 

 

Regards, 

Manikandan 

[Muhammad Waqas]

Appreciate your reply, looking forward to it.  

[Manikandan Murugesan]

Hi Muhammad, 

 

Please use virtualization when rendering a pivot table with a large amount of data. Please refer the following UG document for more information on the "Virtualization" option. 

Document: https://blazor.syncfusion.com/documentation/pivot-table/virtual-scrolling 

 

But, currently we are facing a problem while exporting the pivot table as excel with virtualization, and we have considered this as a bug “Exporting pivot table with number formatting produces corrupted Excel file” and logged a defect report in our database. And the fix will be available in our Volume 4 SP release which is estimated to be rolled out at the end of January 2022. You can track the same by using below link. 

 

https://www.syncfusion.com/feedback/31835/exporting-pivot-table-with-number-formatting-produces-corrupted-excel-file 

 

Please let us know if you have any concerns. 

Regards, 

Manikandan 

[Manikandan Murugesan]

Hi Muhammad, 

 

We are glad to announce that our weekly patch release V19.4.47 is rolled out and fix for the issue “Exporting pivot table with number formatting produces corrupted Excel file” has been included in this release. Please see the following example. 

 

Sample: https://www.syncfusion.com/downloads/support/directtrac/general/ze/WebApplication1-1769617047 

 

We thank you for your support and appreciate your patience in waiting for this release. Please contact us if you require any further assistance. 

 

Regards, 

Manikandan