Re: How to close excel object with C#

[Mary Chipman]

This whitepaper should help:
Programming Office Applications Using Microsoft Visual C#
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/odc_vsto2003_ta/html/OffCSharp.asp

--mary

 

[Mary Chipman]

You need to use the ReleaseComObject method on each and every call. My
understanding of the issue is that Excel opens up a lot of additional
objects under the covers which don't get released. If this isn't
working, look to see what //do some stuff is actually doing and if
this is the problem. You don't want to use GC.Collect -- that forces
collection for all processes. I'm not 100% sure, but I believe it has
no effect on unmanaged code.

--mary

 

[ZeeZuLander]

This is an easy way to do it

Simply call the "Quit()" function of the relevant Excel.Application object. For example...

using Excel = Microsoft.Office.Interop.Excel; 

//this is required because there is otherwise an ambiguity between the Application" class under the Windows.Forms namespace and that of Excel 
//if not you can simply say...

using Microsoft.Office.Interop.Excel;


//Then within your class you create an instance of the Excel.Application class

Excel.Application excel_app = new Excel.Application();

//Do whatever you want
.
.
.
.
.

excel_app.Quit();