How to generate large excel file using

Posted by Sundermagar under ASP.NET on 10/3/2011 | Points: 10 | Views : 2345 | 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


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

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


Sheo Narayan

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

Login to post response