javascript读取本地excel文档并显示在文本框中
当前位置:点晴教程→知识管理交流
→『 技术文档交流 』
本文采用javascript读取本地excel文档数据,并将结果显示在下面的文本域中,具体配置:浏览器:IE,安全设置:默认
示例代码: [code] <script language="javascript"> 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> [/code] 该文章在 2013/6/13 9:16:31 编辑过 |
关键字查询
相关文章
正在查询... |