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

[Ranjith]

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]

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..

[Martin]

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