Sampathkumar
Top achievements
Rank 1
Rank 1
Sampathkumar
asked on 09 Jul 2018, 06:32 AM
Hi All,
I was working on a task to export to excel with 100k rows with 50 columns, but when I click on export to excel it was generating an empty excel .Kindly help me in achieving the task.
Note: This is working well for 6000 rows.
Thanks & Regards,
Sampath
1 Answer, 1 is accepted
0
Hi Sampath,
Based on your post, I believe that the data for the export is too large to be exported on the client side. This is due to the fact that every browser has a limited amount of memory, and when it is reached - unexpected behavior might be observed.
What I could suggest is using server-side export. For example, you could take advantage of our Document processing library:
Demos of the above library are available here:
I hope the above information is useful.
Regards,
Preslav
Progress Telerik
Based on your post, I believe that the data for the export is too large to be exported on the client side. This is due to the fact that every browser has a limited amount of memory, and when it is reached - unexpected behavior might be observed.
What I could suggest is using server-side export. For example, you could take advantage of our Document processing library:
- https://docs.telerik.com/devtools/document-processing/libraries/radspreadstreamprocessing/overview
- https://docs.telerik.com/aspnet-mvc/helpers/grid/excel-export#use-server-side-processing
Demos of the above library are available here:
- https://demos.telerik.com/aspnet-mvc/grid/server-export
- https://demos.telerik.com/aspnet-mvc/spreadprocessing
- https://demos.telerik.com/aspnet-mvc/spreadstreamprocessing
I hope the above information is useful.
Regards,
Preslav
Progress Telerik
Try our brand new, jQuery-free Angular components built from ground-up which deliver the business app essential building blocks - a grid component, data visualization (charts) and form elements.