今天图老师小编给大家介绍下js读取本地excel文档数据，平时喜欢js读取本地excel文档数据的朋友赶紧收藏起来吧！记得点赞哦~
【 tulaoshi.com - Web开发 】
浏览器：IE
安全设置：默认
代码:
（本文来源于图老师网站，更多请访问https://www.tulaoshi.com/webkaifa/）script
function readThis(){
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;i46;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+"");
}
}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
来源:https://www.tulaoshi.com/n/20160219/1623895.html
看过《js读取本地excel文档数据》的人还看了以下文章 更多>>
