我有一个C#控制台程序。当它运行时,会实例化一些Excel对象,例如:(openExcelO)。
当程序运行结束时,我有一个关闭Excel的方法(closeExcel),它应该正确清理Excel进程。在任务管理器中,我可以看到剩余的Excel残留。关闭程序的例子是从互联网上拼凑出来的:
private void openExcelO (string dir) {
try {
xlApp = new Excel.Application();
xlWorkBook = xlApp.Workbooks.Open(dir + "PortfolioOptimization5.xlsm",
0, false, 5, "", "", true,
Microsoft.Office.Interop.Excel.XlPlatform.xlWindows,
"\t", false, false, 0, true, 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进程?
谢谢!
Quit
是否有布尔重载以允许退出时忽略所有错误?Word互操作对象有这个功能。 - Simon MᶜKenzieGC.Collect
之前认真考虑之外,您对GC.Collect
的调用实际上并不能帮助您的对象被收集,因为您的主类仍然持有对每个COM对象的引用。为了使releaseObject
也清除主要引用,请将其更改为releaseObject(ref object obj)
,因为这样当您调用obj = null
时,字段本身将被设置为null。 - Simon MᶜKenzie