注:
不允许调用对象的Application属性,否则资源释放无效。
例:
Excel.Application excelApp = new Excel.Application();
excelApp.Application.DisplayAlerts = false;( excelApp.DisplayAlerts = false;)
如果代码中有以上类似调用的话,资源释放将无效。
Excel.Application excelApp = null;
Excel.Workbook excelBook = null;
Excel.Worksheet excelSheet = null;
excelApp = new Excel.Application();
excelApp.SheetsInNewWorkbok;
excelApp.SheetsInNewWorkbook = 1;
excelBook = excelApp.Workbooks.Add();
excelSheet = excelBook.Worksheets[1];
// 资源释放(下列代码为借鉴他人的)
System.Runtime.InteropServices.Marshal.ReleaseComObject((objec)excelSheet);
System.Runtime.InteropServices.Marshal.ReleaseComObject((objec)excelBook);
excelApp.Quit();
System.Runtime.InteropServices.Marshal.ReleaseComObject((objec)excelApp);
System.GC.Collect();