Ad:

C# Discussion Thread
Unsolved
Views: 5658

Oct 6th, 2008

Cant end the excel process

Expand Post »

Hi, I have problem to terminate the process EXCEL.EXE after I write into it. After the program finish execute. The EXCEL.EXE is still in the proceses list in the task manager. Anyway to terminate it?

Below is my coding:

C# Syntax (Toggle Plain Text)
SaveFileDialog s_Lvl_Max = new SaveFileDialog();
s_Lvl_Max.Filter = "xls files (*.xls)|*.xls|All files (*.*)|*.*";
s_Lvl_Max.FilterIndex = 1;
s_Lvl_Max.FileName = "FileKK" + "_" + comboBox_baseTP.Text;
s_Lvl_Max.OverwritePrompt = true;
 
if (s_Lvl_Max.ShowDialog() == DialogResult.OK)
{
                        Excel.Application oXL;
                        Excel._Workbook oWB;
                        Excel._Worksheet oSheet;
                        Excel.Range oRng;
 
                        try
                        {
                            //Start Excel and get Application object.
                            oXL = new Excel.Application();
                            oXL.Visible = false;
                            oXL.DisplayAlerts = false;
 
                            //Get a new workbook.
                            oWB = (Excel._Workbook)(oXL.Workbooks.Add(Missing.Value));
                            oSheet = (Excel._Worksheet)oWB.Worksheets[1];
 
                            //Add table headers going cell by cell.
                            oSheet.Cells[2, 1] = "Level (Max VCC) Guardband";
                            oSheet.Cells[4, 1] = "Test Name";
                            oSheet.Cells[4, 2] = "Frequency";
                            oSheet.Cells[4, 3] = "[Spec]";
                            oSheet.Cells[4, 4] = "Actual";
                            oSheet.Cells[4, 5] = "temp(V)";
 
                            //Format A1:D1 as bold, vertical alignment = center.
                            oSheet.get_Range("A1", "E1").Font.Bold = true;
                            oSheet.get_Range("A1", "E1").VerticalAlignment = Excel.XlVAlign.xlVAlignCenter;
 
                            // Create an array to multiple values at once.
                            int i = 5;
 
                            foreach (DataRow dr in dtable2.Rows)
                            {
                                oSheet.Cells[i, 1] = dr[0];
                                oSheet.Cells[i, 2] = dr[1];
                                oSheet.Cells[i, 3] = dr[2];
                                oSheet.Cells[i, 4] = dr[3];
                                oSheet.Cells[i, 5] = dr[4];
 
                                i++;
                            }
 
                            i--;
 
                            //AutoFit columns A:D.
                            oRng = oSheet.get_Range("A1", "E1");
                            oRng.EntireColumn.AutoFit();
 
                            oWB.SaveAs(s_Lvl_Max.FileName, Missing.Value, Missing.Value, Missing.Value, Missing.Value,
                            Missing.Value, Excel.XlSaveAsAccessMode.xlExclusive, Missing.Value,
                            Missing.Value, Missing.Value, Missing.Value, Missing.Value);
                            oXL.Quit(); // <--------- try to use this to terminate the process, not working 
                            MessageBox.Show("File has been successfully saved. :)");
}
SaveFileDialog s_Lvl_Max = new SaveFileDialog();
s_Lvl_Max.Filter = "xls files (*.xls)|*.xls|All files (*.*)|*.*";
s_Lvl_Max.FilterIndex = 1;
s_Lvl_Max.FileName = "FileKK" + "_" + comboBox_baseTP.Text;
s_Lvl_Max.OverwritePrompt = true;

if (s_Lvl_Max.ShowDialog() == DialogResult.OK)
{
                        Excel.Application oXL;
                        Excel._Workbook oWB;
                        Excel._Worksheet oSheet;
                        Excel.Range oRng;

                        try
                        {
                            //Start Excel and get Application object.
                            oXL = new Excel.Application();
                            oXL.Visible = false;
                            oXL.DisplayAlerts = false;

                            //Get a new workbook.
                            oWB = (Excel._Workbook)(oXL.Workbooks.Add(Missing.Value));
                            oSheet = (Excel._Worksheet)oWB.Worksheets[1];

                            //Add table headers going cell by cell.
                            oSheet.Cells[2, 1] = "Level (Max VCC) Guardband";
                            oSheet.Cells[4, 1] = "Test Name";
                            oSheet.Cells[4, 2] = "Frequency";
                            oSheet.Cells[4, 3] = "[Spec]";
                            oSheet.Cells[4, 4] = "Actual";
                            oSheet.Cells[4, 5] = "temp(V)";

                            //Format A1:D1 as bold, vertical alignment = center.
                            oSheet.get_Range("A1", "E1").Font.Bold = true;
                            oSheet.get_Range("A1", "E1").VerticalAlignment = Excel.XlVAlign.xlVAlignCenter;

                            // Create an array to multiple values at once.
                            int i = 5;

                            foreach (DataRow dr in dtable2.Rows)
                            {
                                oSheet.Cells[i, 1] = dr[0];
                                oSheet.Cells[i, 2] = dr[1];
                                oSheet.Cells[i, 3] = dr[2];
                                oSheet.Cells[i, 4] = dr[3];
                                oSheet.Cells[i, 5] = dr[4];

                                i++;
                            }

                            i--;

                            //AutoFit columns A:D.
                            oRng = oSheet.get_Range("A1", "E1");
                            oRng.EntireColumn.AutoFit();

                            oWB.SaveAs(s_Lvl_Max.FileName, Missing.Value, Missing.Value, Missing.Value, Missing.Value,
                            Missing.Value, Excel.XlSaveAsAccessMode.xlExclusive, Missing.Value,
                            Missing.Value, Missing.Value, Missing.Value, Missing.Value);
                            oXL.Quit(); // <--------- try to use this to terminate the process, not working 
                            MessageBox.Show("File has been successfully saved. :)");
}

Similar Threads

Open Excel file from Visual Basic in Visual Basic 4 / 5 / 6
Open Excel File in VB.NET
Get data out of excel file stored as an image in MS SQL
Generic Host Process for Win32 Error in Viruses, Spyware and other Nasties
Generic Host Process WIN32 in Viruses, Spyware and other Nasties

raul15791

Reputation Points: 37

Solved Threads: 7

Junior Poster

Offline

102 posts
since Jun 2008

Permalink

Oct 6th, 2008

Re: Cant end the excel process

Try this... Not working either....

C# Syntax (Toggle Plain Text)
// Need all following code to clean up and extingush all references!!!
oWB.Close(null,null,null);
oXL.Workbooks.Close();
oXL.Quit();
System.Runtime.InteropServices.Marshal.ReleaseComObject (oRng);
System.Runtime.InteropServices.Marshal.ReleaseComObject (oXL);
System.Runtime.InteropServices.Marshal.ReleaseComObject (oSheet);
System.Runtime.InteropServices.Marshal.ReleaseComObject (oWB);
oSheet=null;
oWB=null;
oXL = null;
GC.Collect(); // force final cleanup!
// Need all following code to clean up and extingush all references!!!
oWB.Close(null,null,null);
oXL.Workbooks.Close();
oXL.Quit();
System.Runtime.InteropServices.Marshal.ReleaseComObject (oRng);
System.Runtime.InteropServices.Marshal.ReleaseComObject (oXL);
System.Runtime.InteropServices.Marshal.ReleaseComObject (oSheet);
System.Runtime.InteropServices.Marshal.ReleaseComObject (oWB);
oSheet=null;
oWB=null;
oXL = null;
GC.Collect(); // force final cleanup!

Last edited by raul15791; Oct 6th, 2008 at 4:11 am.

raul15791

Reputation Points: 37

Solved Threads: 7

Junior Poster

Offline

102 posts
since Jun 2008

Permalink

Nov 19th, 2008

Re: Cant end the excel process

It may be over a month since you posted but for what it's worth I ran across the same issue and could not find any help on the web so I came up with this code that does the trick. This code loops through all the Excel processes and when it finds the one with the same window title as the application you started it ends that process then exits the loop.

using System.Diagnostics;

foreach (Process p in Process.GetProcessesByName("EXCEL"))
{
if (oXL.Caption == p.MainWindowTitle)
{
p.Kill();
break;
}
}

zarget

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

1 posts
since Nov 2008

Permalink

Nov 19th, 2008

Re: Cant end the excel process

Yeah I guess there's no complete solution for this problem. I found another solution which seems working as well:

C# Syntax (Toggle Plain Text)
// Need all following code to clean up and extingush all references!!!
            oWB.Close(null, null, null);
            oXL.Workbooks.Close();
            Process[] pProcess;
            pProcess = System.Diagnostics.Process.GetProcessesByName("Excel");
            pProcess[0].Kill();
 
            oSheet = null;
            oWB = null;
            oXL = null;
// Need all following code to clean up and extingush all references!!!
            oWB.Close(null, null, null);
            oXL.Workbooks.Close();
            Process[] pProcess;
            pProcess = System.Diagnostics.Process.GetProcessesByName("Excel");
            pProcess[0].Kill();

            oSheet = null;
            oWB = null;
            oXL = null;

Thanks anyway guys for all the help given!!

raul15791

Reputation Points: 37

Solved Threads: 7

Junior Poster

Offline

102 posts
since Jun 2008

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in C# Forum Timeline: asp.net 2005 sending email

Next Thread in C# Forum Timeline: VC# compile problem

DaniWeb Message

Cancel Changes

User Name
Password