Hi Mike,
Could you please let me know more details on the problem. XlsIO usually does not have any problems handling 13,000 rows. Please provide the following details
1) The approximate number of columns
2) Are data being written into a template? If yes would it be possible to send the template to us.
3) If possible a sample to reproduce the problem.
It is likely a bug/bottleneck that is causing this problem. Once we are able to reproduce the problem we will try to fix it as soon as possible. Here is the sample that I had used for testing writing a file with 15,000 rows and 30 columns
F45080Performance.zip
It took 170MB memory on my machine.
Best regards,
Stephen.
>Using XlsIO 4.2.0.37
>
>We have an ASP.NET app which creates large workbooks (> 13,000 rows). It is throwing OutOfMemoryExceptions. That''s bad, but the immediate problem is that after one of these exceptions, the site is effectively dead - all page requests result in OutOfMemoryExceptions. Task Manager shows the memory usage at ~700M - the server has 4G.
>
>I considering isolating XlsIO in its own AppDomain - does anyone have an alternate suggestion?