0

I'm using Microsoft.Office.Interop.Excel.Application to load in an Excel file and read various sheets and whatnot.

As far as I understand, the correct way to close everything is to do:

        Application excel = new Application();
        Workbook wb = excel.Workbooks.Open(filename);
        // do stuff with file
        excel.Workbooks.Close();
        excel.Quit();

The problem is, during debugging my application will throw exceptions or I might just halt the debugger manually. By the end of the day I've got loads of excel.exe processes running and I get a "File is available" dialogue window appearing for each one.

How can I close the excel application properly, despite an exception or debugger halt? Or perhaps there's a different angle I can take, and just run a separate program, at the end of the day, which searches for all Excel instances and closes them.

Notes: This is a WPF project using Visual Studio 2012

Improve this question
3
Related questions
1
Microsoft Interop Excel closing running instances of excel?
0
Opening Excel through C# then allowing the user to close Excel manually
0
Proper way of closing Excel application
Load 7 more related questions Show fewer related questions

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.