Posted 8 September 2017, 2:39 pm EST
I am generating a spread that has about 400 tabs with each tab containing about 300 rows by 40 rows of numeric data. The system easily generates the spread and I can view the data with no issues. When I try saving the spread it throws the exception System.OutOfMemoryException. I have tried saving it to both 2003 excel format and 2007 XML format. Neither attempt will work. While watching the processing thread on my task manager it consumes about 1.3 GB of memory while trying to save.
I have successfully saved all 400 tabs to an excel file when the tabs only contain about 40 rows of data. It generated an excel file was 7MB. So they are not overly large files. I'm not even coming close to hitting any memory limits as I have 8GB total and each 32 bit thread is limited to 2GB. Any ideas on a solution.
Windows 7 x64
RAID 0 system with 4 SSDs
VB.NET Visual Studio 2008