js如何读取客户端Excel文件

最新推荐文章于 2024-07-30 11:29:23 发布

weixin_34194379

最新推荐文章于 2024-07-30 11:29:23 发布

阅读量95

点赞数

原文链接：http://www.cnblogs.com/johan/archive/2012/08/07/2626821.html

版权

详细见 http://www.oejia.net/blog/2012/08/07/Js_read_xls.html

原理是利用了IE关于Excel的ActiveX插件，所以此功能只支持IE系列浏览器

 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){
  document.all.txtArea.value = tempStr;
 } 
 document.all.txtArea.value = tempStr;
 oXL.Quit();
 CollectGarbage();