js读取本地excel文档数据的代码

复制代码 代码如下:

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

  以上代码在需要设置IE安全级别低才能正常运行,贴出来主要是可以学习这方面的技术