我正在开发一个需要从Excel文档中获取数据的Windows 7小工具。问题是,当我检索到所需数据后,Excel进程不会卸载。
这是我在初始化函数中使用的代码:
这一切都被包含在try-catch块中,我可以验证它们都成功了。所有的删除和null赋值都是为了释放对COM对象的引用,但似乎我漏掉了某些东西。有没有办法强制Excel进程卸载?
这是我在初始化函数中使用的代码:
var Excel = new ActiveXObject("Excel.Application");
Excel.Visible = false;
Excel.DisplayAlerts = false;
var workbooks = Excel.Workbooks;
var workbook = workbooks.Open("\\\\SERVER\\Documents\\Sample.xlsx", 0, true);
var activesheet = workbook.ActiveSheet;
var cell = sheet.Cells(1, 1);
var value = cell.Value;
document.getElementById("content").innerHTML = value;
delete value;
value = null;
delete cell;
cell = null;
delete activesheet;
activesheet = null;
delete workbook;
workbook = null;
delete workbooks;
workbooks = null;
Excel.Quit();
delete Excel;
Excel = null;
这一切都被包含在try-catch块中,我可以验证它们都成功了。所有的删除和null赋值都是为了释放对COM对象的引用,但似乎我漏掉了某些东西。有没有办法强制Excel进程卸载?