ASP.NET控制EXCEL,完全结束进程

最新推荐文章于 2020-06-03 11:09:47 发布

原创最新推荐文章于 2020-06-03 11:09:47 发布 · 1.6k 阅读

1 ·

CC 4.0 BY-SA版权

文章标签：

#asp.net #excel #null #存储

博客展示了一段代码，通过创建Excel应用程序对象，打开指定的Excel文件，将其另存为XML格式文件，同时控制存储文件的类型。最后释放相关对象并进行垃圾回收，实现Excel文件的存储转换。

Excel.Application ThisApp = new Excel.ApplicationClass();
   Excel.Workbooks ThisWbs = ThisApp.Workbooks;
   Excel.Workbook ThisWb = ThisWbs.Open("G:/demo.xls",Missing.Value,Missing.Value,Missing.Value,Missing.Value,Missing.Value,Missing.Value,Missing.Value,Missing.Value,Missing.Value,Missing.Value,Missing.Value,Missing.Value,Missing.Value,Missing.Value);
   ThisWb.SaveAs("G:/HelloExcel.xml",Excel.XlFileFormat.xlXMLSpreadsheet,Missing.Value,Missing.Value,Missing.Value,Missing.Value,Excel.XlSaveAsAccessMode.xlNoChange,Missing.Value,Missing.Value,Missing.Value,Missing.Value,Missing.Value);

//Excel.XlFileFormat.xlXMLSpreadsheet控制存储文件的类型
   System.Runtime.InteropServices.Marshal.ReleaseComObject(ThisWb);
   ThisWb = null;
   ThisWbs.Close();
   System.Runtime.InteropServices.Marshal.ReleaseComObject(ThisWbs);
   ThisWbs = null;
   System.Runtime.InteropServices.Marshal.ReleaseComObject(ThisApp);
   ThisApp = null;
   GC.Collect();