Close Excel after use

[Maciej Pietruszka]

My app read from Excel file using Excel's COM dll

I create Excel object by:

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

and next make it inivisible:
ExcelObj.Visible = false;

All works great, but I saw in Task Manager that "excel" process still
exist even my app closed.
Seems to my app create "excel" process and doesnt dispose it

How can I do that programically?

Rgs
Maciej

 

[Nicholas Paldino [.NET/C# MVP]]

Maciej,

You must call Quit before you release the reference to the Excel
application object. This causes Excel to shut down (it is an out of process
COM server) when you release the final reference. Once you call Quit, you
need to call the static ReleaseComObject method on the Marshal class to
release the reference.

You need to be careful if you use properties on the application object
(which I am sure you are) which return other objects. The object model is
such that most every object returned has a reference to the main application
object (so yours is not the only one). Because of this, you need to make
sure that you pass every object exposed through a property or returned
through a method to the ReleaseComObject method on the Marshal class. DON'T
do something like this:

// Set the value on a range.
ExcelObj.Workbooks.Item(1).Worksheets.Item(1).Cells(1, 1).Value = "hello";

This causes SIX com objects to be exposed, most of which have a
reference to the Application object.

Now, if the instance of excel that you are using is pretty localized in
your app (you use it in the course of a method invocation, and don't hold
onto it for a long time), then you ^could^ get away with this, forcing a
garbage collection at the end of your method. However, this could have a
negative impact on your performance, so you would have to consider this
approach very carefully.

Hope this helps.

 

[Carlos J. Quintero [.NET MVP]]

See:

Office application does not quit after automation from Visual Studio .NET
client
http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q317109

--
Best regards,

Carlos J. Quintero

MZ-Tools: Productivity add-ins for Visual Studio .NET, VB6, VB5 and VBA
You can code, design and document much faster.
Free resources for add-in developers:
http://www.mztools.com

 

[Maciej Pietruszka]

Yeah you helped me a lot.
Many thanx!

That was what I've looked for.

Rgs
Maciej