C#使用Excel进程销毁多个Excel对象的正确方法
发布时间:2020-12-16 01:53:50 所属栏目:百科 来源:网络整理
导读:我有一个C#控制台程序.运行时,它会实例化一些Excel对象,例如:(openExcelO). 当程序运行完毕后,我有一个关闭Excel(closeExcel)的方法,它应该正确地清理Excel进程.在任务管理器中,我可以看到剩余的Excel残余.关闭例程从互联网示例拼凑而成: private void ope
我有一个C#控制台程序.运行时,它会实例化一些Excel对象,例如:(openExcelO).
当程序运行完毕后,我有一个关闭Excel(closeExcel)的方法,它应该正确地清理Excel进程.在任务管理器中,我可以看到剩余的Excel残余.关闭例程从互联网示例拼凑而成: private void openExcelO (string dir) { try { xlApp = new Excel.Application(); xlWorkBook = xlApp.Workbooks.Open(dir + "PortfolioOptimization5.xlsm",false,5,"",true,Microsoft.Office.Interop.Excel.XlPlatform.xlWindows,"t",1,0); xlMarkowitz = (Excel.Worksheet)xlWorkBook.Sheets["Markowitz"]; xlWeights = (Excel.Worksheet)xlWorkBook.Sheets["Weights"]; } catch (Exception ex) { ReportError("PortfolioOptimization","openExcel",ex.ToString()); } } private void closeExcel () { object misValue = System.Reflection.Missing.Value; try { if (xlWeights != null) releaSEObject(xlWeights); if (xlMarkowitz != null) releaSEObject(xlMarkowitz); xlWorkBook.Close(false,misValue,misValue); if (xlApp != null) xlApp.Quit(); if (xlWorkBook != null) releaSEObject(xlWorkBook); if (xlApp != null) releaSEObject(xlApp); } catch (Exception ex) { ReportError("PortfolioOptimization","closeExcel",ex.ToString()); } } private void releaSEObject (object obj) { try { System.Runtime.InteropServices.Marshal.ReleaseComObject(obj); obj = null; } catch (Exception ex) { obj = null; ReportError("PortfolioOptimization","releaSEObject","Unable to release object " + ex.ToString()); } finally { GC.Collect(); } } 如何更改关闭例程以正确关闭和清理Excel对象,以便任务管理器中没有延迟的Excel进程? 谢谢! 解决方法
看起来你没有以正确的顺序发布你的对象 – xlApp.Quit可能无法干净地退出,因为你仍然持有对工作簿的引用.您需要在调用Quit之前释放工作簿:
xlWorkBook.Close(false,misValue); releaSEObject(xlWorkBook); xlApp.Quit(); releaSEObject(xlApp); 信用必须转到this StackOverflow answer:还有一些其他隐含的引用,你没有关闭,即,在以下几行: xlWorkBook = xlApp.Workbooks.Open(...) xlWorkBook.Sheets["Markowitz"]; “Workbooks”对象未发布,“Sheets”对象也未发布.你也需要发布这些引用,即: var books = xlApp.Workbooks; books.Open(...); releaSEObject(books); var sheets = xlWorkBook.Sheets; xlMarkowitz = (Excel.Worksheet)sheets["Markowitz"]; xlWeights = (Excel.Worksheet)sheets["Weights"]; releaSEObject(sheets); Bruce Barker的好建议:“永远不要在COM对象上使用两个点”! (编辑:李大同) 【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容! |