How to dispose of Excel.Application class correctly [duplicate]

Question

I have a real pain of an issue whereas the Excel.Application() does not want to get released, no matter what. Even after a new class is instantiated and disposed immediately afterwards, it still appears in the process list.

if (_ExcelApp == null)
    _ExcelApp = new Microsoft.Office.Interop.Excel.Application();
Dispose();

public void Dispose()
{
    if (_ExcelApp != null)
    {
        try
        {
            _ExcelApp.Quit();
            Marshal.FinalReleaseComObject(_ExcelApp);
        }
        catch (Exception) { }
            _ExcelApp = null;
    }
}

Please help!

the best way to dispose of something is to use a using() statement this automatically disposes of objects once they are finished with them — Simon Price
– Simon Price, Commented Nov 1, 2016 at 11:55
Ok, so I've mangaged to set the _ExcelApp and dispose of it immediately. However, If I do _ExcelApp.Workbooks.Add() (note no parameter) and then try to expose of _ExcelApp, it keeps holding on to the application. — Rudolf Lamprecht
– Rudolf Lamprecht, Commented Nov 1, 2016 at 11:58

mojo · Accepted Answer · 2016-11-01 12:18:46Z

4

It do not release because not all COM objects which are related to _ExcelApp released. If you provide all piece of code, it may be more clearer.

Workbooks wb =_ExcelApp.Workbooks;
Workbook book = wb.Add();

Then in try catch:

          try
            {
              book.Close();
              Marshal.ReleaseComObject(book);
              wb.Close();
              Marshal.ReleaseComObject(wb);
              _ExcelApp.Quit();
              Marshal.FinalReleaseComObject(_ExcelApp);
            }
        catch (Exception) { }
            _ExcelApp = null;
    }

_ExcelApp.WorkBooks.Add(); create new WorkBook and you do not release this object. Also it create Workbooks object which also have to be released.

As I have mentioned earlier will be better if you show all code(if it is possible of course)

edited Nov 1, 2016 at 12:18

answered Nov 1, 2016 at 12:03

mojo

1841 gold badge2 silver badges9 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Rudolf Lamprecht Over a year ago

So I ended up releasing each and every COM object after they have been used and setting them to null. It turned out to be a big hassle as I had several ranges of columns and cells, worksheets, workbooks, etc.

Rudolf Lamprecht Over a year ago

Might I add that I did not set the objects to null originally, so that probably was my flaw. Ta mojo

Collectives™ on Stack Overflow

How to dispose of Excel.Application class correctly [duplicate]

1 Answer 1

2 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Linked

Related