OpenXML, OutOfMemory with large report.

Jul 5, 2016 at 5:37 AM
Hello, faced with the problem:
WebSite (ASP.Net, MVC 3 +ClosedXML), When building a large report (~250K rows, 30 columns), I receive an error "System.Out Of Memory". Is there a way to prevent this error?
Jul 5, 2016 at 10:09 AM
I understand that for 250K lines of the report too much, but it is a requirement of the customer to a specific report.