killing Excel instance through ASP.NET

[kunal.kewalramani]

I'm opening an Excel file using ASP.NET, but Excel process remains it is not killed, I tried killing it by using Quit() that is also not working, if anybody have any solution for this please help me out.
*************** *************** *************** *************** **********
Sent via Fuzzy Software @ http://www.fuzzysoftware.com/
Comprehensive, categorised, searchable collection of links to ASP & ASP.NET resources...

[Mark Rae]

"kunal" <ku************ ***@patni.com> wrote in message
news:uo******** ******@TK2MSFTN GP14.phx.gbl...

I'm opening an Excel file using ASP.NET, but Excel process remains it is
not killed, I tried killing
it by using Quit() that is also not working, if anybody have any solution
for this please help me out.

1) Are you instantiating Excel server-side in VB.NET / C# etc, or
client-side using JavaScript / VBScript and ActiveX / WSH?

2) What version of Excel?

3) Please post the code you use to instantiate Excel and open the
workbook(s), plus the code you're using to (try to) kill it.

[kunal.kewalramani]

I'm using C# to instantiate Excel on server side.
Excel version is 9.0
Below is the code written for Excel.
Excel.Applicati onClass oXL = new Excel.Applicati onClass();
oXL.WindowState =Excel.XlWindow State.xlMaximiz ed;
oXL.ShowWindows InTaskbar =true;

//oXL.WindowActiv ate +=Microsoft.Off ice.Interop.Exc el.AppEvents_Wi ndowActivateEve ntHandler;
//oXL.Windows =Microsoft.Offi ce.Interop.Exce l.Windows;
oXL.EnableEvent s=true;
oXL.Visible=tru e;

//oXL.ShowStartup Dialog=true;
//oXL.DisplayExce l4Menus = true;
int hwndExcel;
oXL.Visible=tru e;
oXL.WindowState =Excel.XlWindow State.xlMaximiz ed;
oXL.Caption = "Some Caption For Excel Window";
hwndExcel = MyApi.FindWindo w("XLMAIN",oXL. Caption);
string Excelstr1 = hwndExcel.ToStr ing();

System.Diagnost ics.Process [] processArr2=Sys tem.Diagnostics .Process.GetPro cessesByName("E xcel");
int process2cnt,pro cessid=100000;
for(process2cnt =0;process2cnt< processArr2.Len gth;process2cnt ++)
{
if(processArr2[process2cnt].MainWindowHand le.ToString()== Excelstr1)
{
processid=proce ssArr2[process2cnt].Id;
//processArr2[process2cnt].Kill();
break;
}
}
// Form1 oform1 =new Form1();
//pid=oform1.GetP rocessID(oXL);
//ewclass oewclass =new ewclass();
//pid=oewclass.Ge tProcessID(oXL) ;

if(pid!=100000)
//{
Process.GetProc essById(pid).Ki ll();
}
}

*************** *************** *************** *************** **********
Sent via Fuzzy Software @ http://www.fuzzysoftware.com/
Comprehensive, categorised, searchable collection of links to ASP & ASP.NET resources...

[Steve C. Orr [MVP, MCSD]]

It's not recommended that you create Excel isntances from a server process
like this. Excel wasn't designed for this. However, I do go over the
techniques involved in this article in case you feel like breaking the
rules. As you'll see, killing the Excel process requires a lot of code.
The article also covers other techniques that are less likely to cause
problems.
http://steveorr.net/Articles/ExcelExport.aspx

--
I hope this helps,
Steve C. Orr, MCSD, MVP
http://SteveOrr.net
"kunal" <ku************ ***@patni.com> wrote in message
news:uo******** ******@TK2MSFTN GP14.phx.gbl...

I'm opening an Excel file using ASP.NET, but Excel process remains it is
not killed, I tried killing it by using Quit() that is also not working,
if anybody have any solution for this please help me out.
*************** *************** *************** *************** **********
Sent via Fuzzy Software @ http://www.fuzzysoftware.com/
Comprehensive, categorised, searchable collection of links to ASP &
ASP.NET resources...