ASP.NET控制EXCEL,完全結束進程-WEBASP.NET

精彩推薦

分類最新教程

分類熱點教程

ASP.NET控制EXCEL,完全結束進程

作者：未知

日期：2005-04-15

人氣：

投稿：(轉貼)

來源：未知

字體：大中小

收藏：加入瀏覽器收藏

以下正文：

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();

相關文章：