Excel still running in Task Manager after I've created and closed and Excel file in C#4.0

4
votes

I have a problem releasing Excel from Task Manager after I create an Excel file, Save and Close it from C#.

I use the following code to create the Excel instance:

 Microsoft.Office.Interop.Excel.Application xlApp = new Microsoft.Office.Interop.Excel.Application();

Microsoft.Office.Interop.Excel.Workbook workbook = xlApp.Workbooks.Add(Microsoft.Office.Interop.Excel.XlWBATemplate.xlWBATWorksheet);
Microsoft.Office.Interop.Excel.Worksheet worksheet = (Microsoft.Office.Interop.Excel.Worksheet)workbook.Worksheets[1];

I then populate my worksheet:

worksheet.Cells[1, 1] = "Test";
worksheet.Cells[1, 2] = "Test";
worksheet.Cells[1, 3] = "Test";
worksheet.Cells[1, 4] = "Test";

After that I save the workbook:

workbook.SaveAs(filePath);

Then close it:

workbook.Close(false, false);

and then quit Excel:

xlApp.Quit();

But after I do this Excel still appears in the Task Manager!!?!?

Any idea why this doesn't get closed after I call xlApp.Quit()?

Thanks in advance.

2
c#excel
possible duplicate: stackoverflow.com/questions/1884217/why-does-excel-remain-open – voidengine

2 Answers

6
votes

Maybe you could try dropping Interop and using EPPlus to create/modify Excel files. It's very easy and doesn't relay on having Office on computer.

But if you really want to go with Interop then this might help (I've been using it on my code to make sure everything is disposed properly as I had to create 800+ excel files in few minutes):

        workBook.Close(true, filePathTarget, Missing.Value);
        app.DisplayAlerts = true;
        app.Quit();
        Release(workSheet2);
        Release(workSheet1);
        Release(workBook);
        Release(workBooks);
        Release(app);
        workSheet2 = null;
        workSheet1 = null;
        workBook = null;
        workBooks = null;
        app = null;
        GC.Collect();
        GC.WaitForPendingFinalizers();

Where:

 private static void Release(object obj) {
        // Errors are ignored per Microsoft's suggestion for this type of function:
        // http://support.microsoft.com/default.aspx/kb/317109
        try {
            System.Runtime.InteropServices.Marshal.FinalReleaseComObject(obj);
        } catch {
        }
    }

But i really urge you to try to use EPPlus if you deal with XLSX files only. It works great, it's fast and efficient and doesn't relay on Microsoft Office being installed. After working with it for an hour I dropped Interop 5 minutes later...

0
votes

You need to set the xlApp variable to null to release the COM reference. It is probably COM that is holding the instance open because the reference count is not zero.

xlApp = null;