In my code, am trying to consolidate 20+ excel files that are full of charts and data into one workbook. The average size of each excel file is 4-5 MB. However, when I lead these into my program the memory usage shoots up drastically.
eg: When I open a 4 MB excel file through my program which uses Aspose.Cells the system memory usage goes up by 25-30 MB.
Further more once I am done with the excel file and assign the object a null value, the memory taken up doesn't get released. This cumulative effect leads to a total memory consumtpion of 1.5 GB which is completely unacceptable in my case since my servers don't have that much RAM on them and thats what I need to install this program finally. I also discovered that Aspose.Cells do not have the Dispose() method built in to release memory.
Can you please help me here? Thanks