Close an excel app in C#

[Richie]

I want to close excel application from C#, this is the piece of code I
am trying
"System.Runtime.InteropServices.Marshal.ReleaseCom Object(excelApp);"
GC.Collect();
It ain't working ! Any ideas please !!

Also tried excelApp.Quit();

This is fine, but on viewing "Task List" the application tab shows
"Excel.exe" running. And if I run the program again the message
"Administrator is using the file, file will open in readonly mode" shows.

Any ideas ?

[Patrice]

What if you try to close explicitely the file ?

Patrice

--

"Richie" <an*******@discussions.com> a écrit dans le message de
news:uD**************@TK2MSFTNGP14.phx.gbl...

I want to close excel application from C#, this is the piece of code I
am trying
"System.Runtime.InteropServices.Marshal.ReleaseCom Object(excelApp);"
GC.Collect();
It ain't working ! Any ideas please !!

Also tried excelApp.Quit();

This is fine, but on viewing "Task List" the application tab shows
"Excel.exe" running. And if I run the program again the message
"Administrator is using the file, file will open in readonly mode" shows.

Any ideas ?

[Richie]

Hi Patrice,
Thanks for your time.
I am really new to .net, can you tell me explicitly how to do it through
code ?
Thanks again !

"Patrice" <no****@nowhere.com> wrote in message
news:ul**************@TK2MSFTNGP12.phx.gbl...

What if you try to close explicitely the file ?

Patrice

--

"Richie" <an*******@discussions.com> a écrit dans le message de
news:uD**************@TK2MSFTNGP14.phx.gbl...

I want to close excel application from C#, this is the piece of code I
am trying
"System.Runtime.InteropServices.Marshal.ReleaseCom Object(excelApp);"
GC.Collect();
It ain't working ! Any ideas please !!

Also tried excelApp.Quit();

This is fine, but on viewing "Task List" the application tab shows
"Excel.exe" running. And if I run the program again the message
"Administrator is using the file, file will open in readonly mode" shows.
Any ideas ?

[Patrice]

Nothing to do with .NET.

I meant I suspect the problem could arise when you try to close the Excel
application without first closing explicitely the workbook file.
I would try to close the workbook using the Excel object model before
quitting using the Excel object.

At least you shouldn't have any more the "file is open" error. You'll have
still to check if Excel is still in memory or not...

For now I believe that Excel doesn't "closes" properly if you don't close
yourself the workbook you are working on (remember in interactive mode
you'll have a dialog box asking to save or not).
Patrice

--

"Richie" <an*******@discussions.com> a écrit dans le message de
news:O$**************@TK2MSFTNGP12.phx.gbl...

Hi Patrice,
Thanks for your time.
I am really new to .net, can you tell me explicitly how to do it through
code ?
Thanks again !

"Patrice" <no****@nowhere.com> wrote in message
news:ul**************@TK2MSFTNGP12.phx.gbl...

What if you try to close explicitely the file ?

Patrice

--

"Richie" <an*******@discussions.com> a écrit dans le message de
news:uD**************@TK2MSFTNGP14.phx.gbl...

I want to close excel application from C#, this is the piece of code I
am trying
"System.Runtime.InteropServices.Marshal.ReleaseCom Object(excelApp);"
GC.Collect();
It ain't working ! Any ideas please !!

Also tried excelApp.Quit();

This is fine, but on viewing "Task List" the application tab shows
"Excel.exe" running. And if I run the program again the message
"Administrator is using the file, file will open in readonly mode" shows.
Any ideas ?

[Wiktor Zychla]

> "System.Runtime.InteropServices.Marshal.ReleaseCom Object(excelApp);"

GC.Collect();
It ain't working ! Any ideas please !!

following code works for us, however it is written in VB.NET to simpify the
automation. thus, you will have to rewrite it using reflection to user it
under C#.

the trick is to close all open workbooks before you call quit on Excell
object.

Wiktor Zychla

If Not (oExcel Is Nothing) Then

For i = 1 To oExcel.workbooks.count

oExcel.workbooks(i).close(False)

Next

oExcel.quit()

End If

oExcel = Nothing

GC.Collect()

GC.WaitForPendingFinalizers()

[Richard Blewett [DevelopMentor]]

You shouldn't have to call GC.Collect and GC.WaitForPendingFinalizers. Simply calling Marshal.ReleaseCOMObject should be enough and its far more lightweight than triggering a full gen2 garbage collection.

Regards

Richard Blewett - DevelopMentor
http://www.dotnetconsult.co.uk/weblog
http://www.dotnetconsult.co.uk
GC.Collect()

GC.WaitForPendingFinalizers()