这段时间在VS 2003 的WebForm 方式下对Excel 进行操作，遇到一个最为头疼的问题就是对Excel操作完毕后Excel不能够正常关闭，系统退出后，Excel总是驻留在内存中。但是这段代码放到 WinForm的程序中又没有问题。在网上进行了查找也没有找到有效可行的办法。经过无数次的尝试，终于解决如下：
原来书写如下：
以下是引用片段：
private Excel.Application m_app;
private Excel.Workbook m_workbook;
this.m_app = new Excel.ApplicationClass();
this.m_app.DisplayAlerts = false;
this.m_workbook = this.m_app.Workbooks.Open(sFilePath, 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 ); |
修改后如下：
以下是引用片段：
private Excel.Application m_app;
private Excel.Workbooks m_workbooks;
private Excel.Workbook m_workbook;
this.m_app = new Excel.ApplicationClass();
this.m_app.DisplayAlerts = false;
m_workbooks = this.m_app.Workbooks;
this.m_workbook = this.m_workbooks.Open(sFilePath, 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 ); |
[1] [2] 下一页 |
