The control should allow you to write directly to the response stream rather than building the file in RAM and then streaming the entire file through the response stream.

This should actually be pretty simple -- I'd imagine that currently the file is written to a memory stream.  Just change that to the response stream, problem solved.

If the data set itself is too large, then you simply load chunks of it.  At this point we are probably over the limit of what should be done by a web server - but the limitations that you're describing here are created by the constraints of your controls.

Hello,

Sorry but i have no idea why they use this method.
But i am sure that there must be some reason to do this.

Note : But to avoid this issue You can export large amount of record by using Telerik Report,RDLC report, Crystal Report, RDL report.

Thanks,
Jayesh Goyani

actually even if the grid successfully exported 100K you will face another problem which is network error....., so i think we have to accept the limitation of working in WEB DEVELOPMENT, and it's better to come with a new ideas not just stop, we should look out of the box, and i prefer Telerik to support Export Paging with the Max Allowed records in a separate sub-control like the pager control or the ToolBar control

When perform ExportToExcel() function, excel sheet is downloading with size 18 MB and but actual size of file is 9 MB only.

Why it is downloading with double size, do not have idea. Can some body help on this?