cannot kill excel process

[charmis]

Hi everyone,

I am trying to include one feature using excel object in my application.

I am giving the code to create and kill the process , that i got from
Microsoft site.......but nothing is happening

it will create one process but , it wont close . i used the code from the
link below:

http://www.dotnet247.com/247referenc...m/?kbid=317109

How can i kill the process?

Also will this work in Windows server 2003

// function

private void NAR(object o)

{

try

{

System.Runtime.InteropServices.Marshal.ReleaseComO bject(o);

}

catch {}

finally

{

o = null;

}

}

// button click

private void Button1_Click(object sender, System.EventArgs e)

{
PIA.ApplicationClass excelApplication = new PIA.ApplicationClass();

PIA.Workbook excelWorkbook =
((PIA.Workbook)excelApplication.Workbooks.Add(Syst em.Reflection.Missing.Value));

PIA.Worksheet excelSheet = ((PIA.Worksheet)(excelWorkbook.ActiveSheet));

NAR(excelSheet);

excelWorkbook.Close(false,null,null);

NAR(excelWorkbook);

excelApplication.Quit();

NAR(excelApplication);
Debug.WriteLine("Sleeping...");

System.Threading.Thread.Sleep(1000);

Debug.WriteLine("End Excel");

GC.Collect();

GC.WaitForPendingFinalizers();
}

thanks & regards

charmis

[Tom Kaminski [MVP]]

"charmis" <ch*****@hotmail.com> wrote in message
news:ui**************@TK2MSFTNGP10.phx.gbl...

Hi everyone,

I am trying to include one feature using excel object in my application.

I am giving the code to create and kill the process , that i got from
Microsoft site.......but nothing is happening

it will create one process but , it wont close . i used the code from the
link below:

http://www.dotnet247.com/247referenc...m/?kbid=317109

Don't use that example, it is for client-side code. It is a bad practice to
use Office objects in server-side code:
http://support.microsoft.com/kb/257757

Find an alternate way to do what you need.

[Elton Wang]

After releasing Com Object, force Garbage Collection, you
will kill EXCEL process immediately:

exBook.Close();
app.Quit();
System.Runtime.InteropServices.Marshal.ReleaseComO bject
(app);
GC.Collect();

Elton Wang
el********@hotmail.com

-----Original Message-----
Hi everyone,

I am trying to include one feature using excel object in my application.
I am giving the code to create and kill the process , that i got fromMicrosoft site.......but nothing is happening

it will create one process but , it wont close . i used the code from thelink below:

http://www.dotnet247.com/247reference/a.aspx? u=http://support.microsoft.com/?kbid=317109
How can i kill the process?

Also will this work in Windows server 2003

// function

private void NAR(object o)

{

try

{

System.Runtime.InteropServices.Marshal.ReleaseCom Object (o);
}

catch {}

finally

{

o = null;

}

}

// button click

private void Button1_Click(object sender, System.EventArgs e)
{
PIA.ApplicationClass excelApplication = new PIA.ApplicationClass();
PIA.Workbook excelWorkbook =
((PIA.Workbook)excelApplication.Workbooks.Add (System.Reflection.Missing.Value));
PIA.Worksheet excelSheet = ((PIA.Worksheet) (excelWorkbook.ActiveSheet));
NAR(excelSheet);

excelWorkbook.Close(false,null,null);

NAR(excelWorkbook);

excelApplication.Quit();

NAR(excelApplication);
Debug.WriteLine("Sleeping...");

System.Threading.Thread.Sleep(1000);

Debug.WriteLine("End Excel");

GC.Collect();

GC.WaitForPendingFinalizers();
}

thanks & regards

charmis




.