Unable to release Excel COM object
 

Hi,

I have to code a ASP.Net application, where the user will be able to open an
excel file on clicking a web button. I have implemented the application using
Excel PIA of Office 2k3. I have completed the code, but
the Excel.exe process is still visible in the Task Manager.

The code i use to close Excel object is given below.
// m_Excel is Excel.Application object
if(m_Excel != null)
{
m_Excel.Quit();
m_Excel = null;
GC.Collect();
GC.WaitForPendingFinalizers();
GC.Collect();
GC.WaitForPendingFinalizers();
}

The code compiles and executes properly. But after I close the application,
I can still view the Excel.exe process in the Task Manager. The process
remains in the background untill I close it manually.

I also tried using ReleaseCOMObject but was unsuccessful.

I tried the methods in the following URL, but nothing worked.
http://msdn.microsoft.com/office/pro...ych2_part2_rco

Does anyone know the solution to the problem.
Can anyone tell me the way to

Unable to release Excel COM object
 

You have to be sure you release all object variables, not only the "m_Excel"
application.
Also, make sure all your variables are fully qualified.
Use
m_Excel.Workbooks("Whatever.xls").Worksheets("Whic hOne").Range("A1")

NickHK

"Avadhoot" ...
Hi,

I have to code a ASP.Net application, where the user will be able to open
an
excel file on clicking a web button. I have implemented the application
using
Excel PIA of Office 2k3. I have completed the code, but
the Excel.exe process is still visible in the Task Manager.

The code i use to close Excel object is given below.
// m_Excel is Excel.Application object
if(m_Excel != null)
{
m_Excel.Quit();
m_Excel = null;
GC.Collect();
GC.WaitForPendingFinalizers();
GC.Collect();
GC.WaitForPendingFinalizers();
}

The code compiles and executes properly. But after I close the
application,
I can still view the Excel.exe process in the Task Manager. The process
remains in the background untill I close it manually.

I also tried using ReleaseCOMObject but was unsuccessful.

I tried the methods in the following URL, but nothing worked.
http://msdn.microsoft.com/office/pro...ych2_part2_rco

Does anyone know the solution to the problem.
Can anyone tell me the way to