C# Removing Excel object from Task Manager

[dsrao]

Hi All, I am unable to close Microsoft Excel object from Task Manager.what i am doing as follows ************ Sample Code********************* Excel._Application _excel = new Excel.ApplicationClass(); Excel.Workbook wsWorkbook = _excel.Workbooks.Open(@"C:\test.xls",0, false, 1, "", "", false, Excel.XlPlatform.xlWindows, "",true, false, 0, true, false, false); Excel._Worksheet sheet = (Excel._Worksheet)wsWorkbook.ActiveSheet; sheet.Activate(); ((Excel.Range)sheet.Cells [1,2]).EntireColumn.NumberFormat =0; ((Excel.Range)sheet.Cells [1,2]).EntireColumn.AutoFit(); ((Excel.Range)sheet.Cells [1,3]).EntireColumn.NumberFormat ="$#,##0.00"; ((Excel.Range)sheet.Cells [1,3]).EntireColumn.AutoFit(); wsWorkbook.Close(true,missing.Value,missing.Value ); // _excel.Visible = true; _excel.Quit(); MessageBox.Show("Done"); **************code end here*******************8 I am opening existing .xls file using C# and formatting some columns. It doesn't release object from Task manager memory. I used Excel.quit() and excel.close(); Please let me know why is object not realsed. Thanks & Regards Rao

[LeenaSo]

Add this in the end to release the objects :) wsWorkbook = null; _excel = null;

[minhpc_bk]

Office application does not quit after automation from Visual Studio .NET client[^]

[miah alom]

[DllImport("user32.dll", EntryPoint="GetWindowThreadProcessId")] public static extern uint GetWindowThreadProcessId(int Hwnd, ref int ProcessID); private int importExcelProcessID = 0; Do this in the beginning Excel._Application _excel = new Excel.ApplicationClass(); GetWindowThreadProcessId(_excel.Hwnd, ref this.importExcelProcessID); When the App ends do this if (this.importExcelProcessID != 0) { Process.GetProcessById(this.importExcelProcessID).Kill(); }

[dsrao]

Thank you ... But doesn't work... Thanks & Regards Rao

[dsrao]

Thank you ... Thanks & Regards Rao

[Anonymous]

Does it work for you? alam_pune