js读取本地excel文档数据

王朝html/css/js·作者佚名  2008-08-20
窄屏简体版  字體: |||超大  

浏览器:IE

安全设置:默认

代码:

<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;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>

 
 
 
免责声明:本文为网络用户发布,其观点仅代表作者个人观点,与本站无关,本站仅提供信息存储服务。文中陈述内容未经本站证实,其真实性、完整性、及时性本站不作任何保证或承诺,请读者仅作参考,并请自行核实相关内容。
 
 
© 2005- 王朝網路 版權所有 導航