I am processing a List of WorkBooks in a loop.
I also will be creating temp Workbook for each workbook.
I see that the WorkBook, Cells, Worksheet objects doesn’t have dispose method.
Are these objects use purely .NET properties?
How do I make sure that these heavy objects are Garbage Collected once they go out of scope.
I am currently just resetting the object to null in the finally block, like:
workbook = new Workbook();
workbook = null;
Please suggest if there is a better way to make sure I don’t ran out of memory while in the middle of processing the Workbooks.