javascript读取Excel

<script> function test(a) { if(a==null) { a="无"; } return a; } function readExcel() { var filePath; filePath=document.act_form.upfile.value; filePath=filePath.replace("//","////"); var i; i = 1; var oXL = new ActiveXObject("Excel.Application"); var oWB = oXL.Workbooks.open(filePath); var oSheet = oWB.ActiveSheet; var colcount=oWB.Worksheets(1).UsedRange.Cells.Rows.Count var colcolumn=oWB.Worksheets(1).UsedRange.Columns.Count var html_code; html_code = ""; html_code+="<center><table><tr><td width=10 height=17><div align=right><strong>工号</strong></div></td><td width=10 align=center><strong>系数</strong></td><td><div align=center><strong>奖金1</strong></div></td><td><div align=center><strong>备注</strong></div></td><td><div align=center><strong>奖金2</strong></div></td>" html_code+="<td><div align=center><strong>备注</strong></div></td>" html_code+="<td><div align=center><strong>奖金3</strong></div></td>" html_code+="<td><div align=center><strong>备注</strong></div></td>" html_code+="<td><div align=center><strong>扣罚1</strong></div></td>" html_code+="<td><div align=center><strong>备注</strong></div></td>" html_code+="<td><div align=center><strong>扣罚2</strong></div></td>" html_code+="<td><div align=center><strong>备注</strong></div></td>" html_code+="<td><div align=center><strong>主管评价</strong></div></td>" html_code+= "</tr>" while(i<=colcount) { if(oSheet.Cells(i,1).value) html_code+= "<tr>" html_code+= "<td><input type=text size=5 name = UID value="+oSheet.Cells(i,1).value+"></td>" html_code+= "<td><input type=text size=5 name = personalCoefficient value="+oSheet.Cells(i,2).value+"></td>" html_code+= "<td><input type=text size=8 name = bonusMoney value="+test(oSheet.Cells(i,4).value)+"></td>" html_code+= "<td><input type=text size=8 name = bonusRemark value="+test(oSheet.Cells(i,5).value)+"></td>" html_code+= "<td><input type=text size=8 name = bonusMoneyOne value="+test(oSheet.Cells(i,6).value)+"></td>" html_code+= "<td><input type=text size=8 name = bonusRemarkOne value="+test(oSheet.Cells(i,7).value)+"></td>" html_code+= "<td><input type=text size=8 name = bonusMoneyTwo value="+test(oSheet.Cells(i,8).value)+"></td>" html_code+= "<td><input type=text size=8 name = bonusRemarkTwo value="+test(oSheet.Cells(i,9).value)+"></td>" html_code+= "<td><input type=text size=8 name = buckleMoney value="+test(oSheet.Cells(i,10).value)+"></td>" html_code+= "<td><input type=text size=8 name = buckleRemark value="+test(oSheet.Cells(i,11).value)+"></td>" html_code+= "<td><input type=text size=8 name = buckleMoneyOne value="+test(oSheet.Cells(i,12).value)+"></td>" html_code+= " <td><input type=text size=8 name = buckleRemarkOne value="+test(oSheet.Cells(i,13).value)+"></td>" html_code+= "<td><textarea name = remark cols=20 rows=3>"+test(oSheet.Cells(i,3).value)+"" html_code+= "" i=i+1 } oWB.close(); html_code+="" ht_v.innerHTML=html_code document.getElementById("sumit").value="重新读取" }

var idTmr=""; function readExcel() { try { var name=new Array(); var x=0; var card=new Array(); var y=0; var oXL=new ActiveXObject("Excel.application"); var path=document.getElementById("file").value; var oWB=oXL.Workbooks.open(path); oWB.worksheets(1).select(); var oSheet=oWB.ActiveSheet; for(var i=1;i<1000;i++) { if(oSheet.Cells(i,1).value!=undefined) { name[x]=oSheet.Cells(i,1).value; x++; card[y]=oSheet.Cells(i,2).value; y++; } else { break; } } document.getElementById("i_name").value=""; document.getElementById("i_sfzh").value=""; document.getElementById("i_name").value=name.toString(); var jclx="<%=jclx%>"; if(jclx!="WB") { document.getElementById("i_sfzh").value=card.toString(); } oXL.Quit(); forInputHidden(); idTmr =window.setInterval("Cleanup();",1); } catch(err) { alert( "出错了, "+err.message); } } function Cleanup()//杀死excel.exe进程 { window.clearInterval(idTmr); CollectGarbage(); }