How to generate large excel file using asp.net

Posted by Sundermagar under ASP.NET on 10/3/2011 | Points: 10 | Views : 2441 | Status : [Member] | Replies : 1
Hello All,

I am trying to generate excel file using C# dynamically depending on my SQL result; my result has approx. 200000 records. The server responds with MUTEXT error in between and fails to generate excel sheet.

Is anyone aware of the technique generating large excel sheet dynamically using C# without memory error?


Thanks in advance.

Sunder Magar


Responses

Posted by: SheoNarayan on: 10/3/2011 [Administrator] HonoraryPlatinum | Points: 25

Up
0
Down
I am not sure but looks like you will have to increase the execution time out from your web.config file as generating excel file of large data takes time and in between it may be timing out.

Have a look at this thread to know how to increase the execution time out http://www.dotnetfunda.com/forums/thread154-systemwebhttpexception-request-timed-out-error-while-accessing-my.aspx.

Thanks

Regards,
Sheo Narayan
http://www.dotnetfunda.com

Sundermagar, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response