This project has moved and is read-only. For the latest updates, please go here.

system out of memory exception at Saveas

Oct 20, 2015 at 11:25 PM
Edited Oct 20, 2015 at 11:26 PM
I have the system out of memory exception at try to save my document, how can i save my workBook?

Is a .xlsx with 20 sheets and per sheet have like a 10000 rows and i have groups

I used the using keyword and i put the data by a list,
Oct 26, 2015 at 10:55 AM
JoseValdez wrote:
I have the system out of memory exception at try to save my document, how can i save my workBook?

Is a .xlsx with 20 sheets and per sheet have like a 10000 rows and i have groups

I used the using keyword and i put the data by a list,
Do you try to fill only one sheet, and then save the document, close and dispose, and after that reopen the document, save another sheet, and so on.
This should be avoid increase the memory size.
Take a look an example in OpenXML http://www.codeproject.com/Tips/659666/Export-very-large-data-to-Excel-file