IE6下js读excel,用ActiveXObject("Excel.Application"),oXL.Workbooks.open('xxx')报错
各位大神帮忙看一下,我在IE6下oXL = new ActiveXObject("Excel.Application")报错,后来查资料说改为ActiveXObject("Microsoft.XMLHTTP")用这个然后报workbooks为空或不是对象这个错,大神们看一下这是什么原因怎么改?
具体代码如下:
function readExcel(){
var fileName = document.getElementById("uploadFile").value;
if(fileName == ""){
$.alert('请选择xxx文件');
return;
}
oXL = new ActiveXObject("Excel.Application");
oWB = oXL.Workbooks.open(fileName);
oSheet = oWB.ActiveSheet;
try{
rowCount = oSheet.usedrange.rows.count;
var ds1 = $.ds('wxld_right');
var ds2 = $.ds('wxld_error');
ds1.clear();
ds2.clear();
errNum = 0;
for(var row=2; row<=rowCount; row++){
var validRes = checkFloor(oSheet.Cells(row,1).value);
if(validRes.length <= 0){
var record = ds1.insertRecord();
record.setValue("build_name", oSheet.Cells(row,1).value);
record.setValue("remark", oSheet.Cells(row,2).value);
record.setValue("validMes", "校验通过");
}
else{
var record = ds2.insertRecord();
record.setValue("build_name", oSheet.Cells(row,1).value);
record.setValue("remark", oSheet.Cells(row,2).value);
record.setValue("validMes", validRes);
errNum ++;
}
}
}
catch(e){
}
finally{
oSheet=null;
oWB.close();
oXL=null;
}
if(errNum > 0){
$.showTab("tabs", "校验不通过列表") ;
}
else{
$.showTab("tabs", "校验通过列表") ;
}
}