Export all the data to Excel or PDF when we have more than 75000 records on the Grid ?

1 Answer 247 Views
Excel Export PDF Export
Ranjith
Top achievements
Rank 1
Iron
Ranjith asked on 14 Jun 2021, 09:45 AM

Currently , I enabled Vitual scrolling with 75000 records. and we also have format logic applied in the view side... For example , We may receive from backend enum values ( status : 0 , 1, 2 ) , Front end -> It will get displayed 0 means Ok , 1 means Fault etc..

Is there any best practises to export large data sets ( rendered one ) ?

There is no formatter applied in the server side. . How to download all the data without performance issue ?

Please answer. 

 

Ranjith
Top achievements
Rank 1
Iron
commented on 15 Jun 2021, 11:16 AM

I understand there is a limitaion "During the export to Excel, the Grid does not use column formats. Column formats are incompatible with Excel" from Kendo..

I was able to use the fetchData option to export all the data by implementing the new API call to get the complete response. I did't apply any formatter logic.

Please share the best practices..

1 Answer, 1 is accepted

Sort by
0
Martin
Telerik team
answered on 17 Jun 2021, 07:28 AM | edited on 17 Jun 2021, 07:28 AM

Hi Ranjith,

Handling the fetchData callback of the kendo-grid-excel component is the right way to go in this case.

Indeed there are certain browser and system-specific limitations beyond our control when downloading large data, but they are varying depending on the use case. For scenarios where the browser cannot handle the created file, we recommend using a server-side solution:

You can use a server-side proxy when the produced files are too large or the browser does not support the file saver API:

https://www.telerik.com/kendo-angular-ui/components/excel-export/api/ExcelExportComponent/#toc-forceproxy

https://www.telerik.com/kendo-angular-ui/components/excel-export/api/ExcelExportComponent/#toc-proxyurl

Here are sample server-side proxy implementations:

https://www.telerik.com/kendo-angular-ui/components/file-saver/#toc-server-proxy

https://www.telerik.com/kendo-angular-ui/components/file-saver/#toc-implementations

The sample server proxy implementations are not Kendo UI for Angular specific - they just represent the endpoint set via the proxyUrl option that will be hit.

On the other hand, if the generated workbooks are so large that they crash the browser, the only available option remains a server-side solution:

https://docs.telerik.com/aspnet-mvc/helpers/grid/excel-export#use-server-side-processing

https://docs.telerik.com/devtools/document-processing/introduction#libraries

However, as this type of solution is not directly related to the Kendo UI for Angular built-in functionality and API, I can suggest creating a separate thread for the respective product if you have further questions on the specifics of using these libraries.

Regards,
Martin
Progress Telerik

Love the Telerik and Kendo UI products and believe more people should try them? Invite a fellow developer to become a Progress customer and each of you can get a $50 Amazon gift voucher.

Tags
Excel Export PDF Export
Asked by
Ranjith
Top achievements
Rank 1
Iron
Answers by
Martin
Telerik team
Share this question
or