In our code we generate an excel workbook.
We uses Aspose.Cells v.4.4
Before Workbook.Save(fileName) is called garbage collector (GC.GetTotalMemory method) says that our application uses ~169Mb memory. Just after WorkBooks.Save(fileName) method is called the same method says that ~223Mb memory has been used. It means that sometimes we have OutOfMemoryException, when, for instance initially, the application works with a bigger report and uses more than 200Mb memory.
Here are a few results for Aspose.Cells. v.4.5:
Before Workbook.Save(fileName) is called: ~896Mb 8-(
After Workbook.Save(fileName) is called: ~976Mb
Please help us to solve the issue.
I have used the code from your site (CreateAsposeCellsFile1 method) with 20000 rows and 100 columns. The result file size is about 5Mb. How the same data can occupy > 200 Mb in memory? 8-(
Here are some detail test results:
=== Aspose.Cells, Version=126.96.36.199, Culture=neutral, PublicKeyToken=9a40d5a4b59e5256 ===
Start CreateAsposeCellsFile1 627208 b = 0 Mb
Workbook has been created 635400 b = 0 Mb
Before AutoFitRows 265125032 b = 252 Mb
Before Save 264400320 b = 252 Mb
After Save 376647516 b = 359 Mb
Time consumed (Seconds): 112.346626
=== Aspose.Cells, Version=188.8.131.52, Culture=neutral, PublicKeyToken=716fcc553a201e56 ===
Start CreateAsposeCellsFile1 700936 b = 0 Mb
Workbook has been created 709128 b = 0 Mb
Before AutoFitRows 276634048 b = 263 Mb
Before Save 277682868 b = 264 Mb
After Save 461774320 b = 440 Mb
Time consumed (Seconds): 99.4869218
Please help to solve the issue.
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />