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.