Good day to everyone.

I am having dificulties using EasyXLS 6.1 in my C# projects. I would like you to provide an exact procedure for disposing memory of your ExcelDocument object. The problem which I encounter is quite simple as that I have a feeling that memory is not cleared after calling Dispose method of ExcelDocument object

What I mean is:
///////////////////////////////////////////////////////
ExcelDocument xls = new ExcelDocument();
xls.easy_LoadXLSFile( stream );

// doing something with ExcelDocument, ExcelTable, ExcelCell etc...

xls.Dispose()
////////////////////////////////////////////////////////

The memory is not cleared after the last line of code above.

Thanks in advance!

The memory is not clean each time when an object is disposed. .NET Framework uses an optimized algorithm for releasing memory. You may force the Garbage Collector to deallocate unused memory, using the System.GC.Collect() method. But this does not guarantee that the memory will be release for sure. If enough memory will be available, the memory will not be released at all.

Thanks for a quick answer!

I understand all this perfectly well. I tried to call GC.Collect() explicitly but memory was not cleared. The real reason I asked this question is an exception trown by .net claiming "Out of memory" after loading 36M excel file. I would like to hear your suggestion on the issue.

This depends on your computer performances. Your file is very big and it consumes at lot of memory when loading and more memory when writing, if this is the case.
Here is a post that contains one of our big volume tests :
http://forum.easyxls.com/viewtopic.php?t=1074

Thank you for information.
As I wrote above I would like you to provide an exact procedure for disposing memory of your ExcelDocument object. We really need it to make absolutely sure that we dispose all EasyXLS objects correctly.

The only thing you can do is calling the System.GC.Collect() method.

Thank you for a quick response.
As far as I understand you the desired procedure for disposing memory of all EasyXLS objects should be a simple one like this:

/////////////////////////////////////////////////////////////////////
ExcelDocument xls = new ExcelDocument();

// Doing something with ExcelDocument, ExcelTable, ExcelCell

xls.Dispose();
System.GC.Collect();
/////////////////////////////////////////////////////////////////////

Am I right?

Right