测试js读取本地excel文档数据

来源：互联网发布：微信62数据源码编辑：程序博客网时间：2024/05/16 10:21

{ var tempStr = ""; var filePath= document.all.upfile.value; var oXL = new ActiveXObject("Excel.application");

var oWB = oXL.Workbooks.open(filePath); oWB.worksheets(1).select(); var oSheet = oWB.ActiveSheet; try{ for(var i=2;i<46;i++){ if(oSheet.Cells(i,2).value =="null" || oSheet.Cells(i,3).value =="null" ) break; var a = oSheet.Cells(i,2).value.toString()=="undefined"?"":oSheet.Cells(i,2).value; tempStr+=(" "+oSheet.Cells(i,2).value+ " "+oSheet.Cells(i,3).value+ " "+oSheet.Cells(i,4).value+ " "+oSheet.Cells(i,5).value+ " "+oSheet.Cells(i,6).value+"/n"); } }

catch(e){ //alert(e); document.all.txtArea.value = tempStr; }

document.all.txtArea.value = tempStr; oXL.Quit(); CollectGarbage();
}
</script>

<html><input type="file" id="upfile" /><input type="button" onclick="readThis();" value="读取"><br><textarea id="txtArea" cols=50 rows=10></textarea></html>