How to generate large excel file using asp.net

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

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

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

Reply | Reply with Attachment

Alert Moderator

Responses

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

0	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

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

Latest Posts