var xls = new ActiveXObject("Excel.Application");
xls.visible = true;//false;
xls.workbooks.open("excel 文件路径");
var xlsbook = xls.activeworkbook;
var xlssheet = xlsbook.worksheets(1);
xlssheet.cells(1,1).value = "js op excel";
xlsbook.save;
xls.quit;
xls = null;
delete xls;
xls.visible = true;//false;
xls.workbooks.open("excel 文件路径");
var xlsbook = xls.activeworkbook;
var xlssheet = xlsbook.worksheets(1);
xlssheet.cells(1,1).value = "js op excel";
xlsbook.save;
xls.quit;
xls = null;
delete xls;
我测试一下。
老大,我改成: xls.workbooks.open("lskcqcb.xls"); //lskcqcb.xls在当前目录有这文件。
打开是空的。
急盼。