C#使用后关闭Excel [英] C# closing Excel after using
本文介绍了C#使用后关闭Excel的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我在应用程序中将Excel用作Com对象.有代码示例
I use Excel as Com object in my application. There is code example
public void LoadData()
{
LogHandler logHandler = new LogHandler(Path.GetDirectoryName(FileName) + "\\logfile.log");
string OKATO = GetOKATOFromFileName();
int SubjectId;
if (!int.TryParse(OKATO, out SubjectId))
{
logHandler.WriteLogStr("Ошибка определения ОКАТО из имени файла (" + FileName + ")");
return;
}
int CL;
DateTime FDate = GetDateFromFileName(out CL);
Excel.Application excelApp = new Excel.Application();
Excel.Workbook excelWorkbook = excelApp.Workbooks.Open(FileName,
0, false, 5, "", "", false, Excel.XlPlatform.xlWindows, "",
true, false, 0, true, false, false);
try
{
Excel.Sheets excelSheets = excelWorkbook.Worksheets;
for (int i = 1; i <= excelSheets.Count; i++)
{
Excel.Worksheet excelWorksheet = (Excel.Worksheet)excelSheets.get_Item(i);
LoadDataFromSheet(excelWorksheet, SubjectId, CL, FDate);
System.Runtime.InteropServices.Marshal.ReleaseComObject(excelWorksheet);
}
System.Runtime.InteropServices.Marshal.ReleaseComObject(excelSheets);
}
catch (Exception le)
{
logHandler.WriteLogStr(le.Message);
}
finally
{
excelWorkbook.Close(0);
excelApp.Quit();
System.Runtime.InteropServices.Marshal.ReleaseComObject(excelWorkbook);
System.Runtime.InteropServices.Marshal.ReleaseComObject(excelApp);
}
}
从void退出后,我希望在出现此代码的情况下Excel将从内存中消失
After exiting from void I expect that Excel will disappear from memory in case of this code
finally
{
excelWorkbook.Close(0);
excelApp.Quit();
System.Runtime.InteropServices.Marshal.ReleaseComObject(excelWorkbook);
System.Runtime.InteropServices.Marshal.ReleaseComObject(excelApp);
}
但不是.直到程序关闭,Excel才存在于内存中.仅在关闭我的应用程序后退出.
but it doesn't. Until program closed Excel exists in memory. It quits only after closing my application.
如何在关闭应用程序之前关闭Excel进程.
How can I close Excel process before I close my application.
p.s.我已阅读此主题在C#中关闭Excel应用程序进程数据访问之后,但没有建议对我有用
p.s. I've read this topic Closing Excel Application Process in C# after Data Access but none of the suggestions work for me
推荐答案
处理完对象后,使用
GC.Collect();
这就是我处置Excel对象的方式
This is how I dispose my Excel object
private void releaseObject(object obj)
{
try
{
System.Runtime.InteropServices.Marshal.ReleaseComObject(obj);
obj = null;
}
catch (Exception ex)
{
obj = null;
MessageBox.Show("Exception Occured while releasing object " + ex.ToString());
}
finally
{
GC.Collect();
}
}
这篇关于C#使用后关闭Excel的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文