代码如下:
finally
{
workbook.Close(false, null, null);
workbooks.Close();
myExcel.Quit(); System.Runtime.InteropServices.Marshal.ReleaseComObject(mySheet);
mySheet = null;
System.Runtime.InteropServices.Marshal.ReleaseComObject(workbook);
workbook = null;
workbooks.Close();
System.Runtime.InteropServices.Marshal.ReleaseComObject(workbooks);
workbooks = null;
System.Runtime.InteropServices.Marshal.ReleaseComObject(myExcel);
myExcel = null;
missing = null;
GC.Collect();
}
但是问题是总有一个进程是结束不了的
比如使用了N次,如果不加以上代码会有N个Excel.exe
但是加了这段代码还是有一个Excel.exe请问这是为什么?
怎么解决呢?
finally
{
workbook.Close(false, null, null);
workbooks.Close();
myExcel.Quit(); System.Runtime.InteropServices.Marshal.ReleaseComObject(mySheet);
mySheet = null;
System.Runtime.InteropServices.Marshal.ReleaseComObject(workbook);
workbook = null;
workbooks.Close();
System.Runtime.InteropServices.Marshal.ReleaseComObject(workbooks);
workbooks = null;
System.Runtime.InteropServices.Marshal.ReleaseComObject(myExcel);
myExcel = null;
missing = null;
GC.Collect();
}
但是问题是总有一个进程是结束不了的
比如使用了N次,如果不加以上代码会有N个Excel.exe
但是加了这段代码还是有一个Excel.exe请问这是为什么?
怎么解决呢?
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货