javascript读取Excel

最新推荐文章于 2026-05-14 15:04:26 发布

转载最新推荐文章于 2026-05-14 15:04:26 发布 · 2.2k 阅读

标签

#javascript #excel #html #function #null

JavaScript 专栏收录该内容

1 篇文章

订阅专栏

本文介绍了一种使用JavaScript和Excel对象模型从Excel文件中读取数据，并将其转换为HTML表格的方法。此过程涉及使用ActiveX对象打开Excel文件、遍历工作表中的单元格并将数据填充到HTML输入字段中。

<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)+"</textarea></td>"

     html_code+= "<tr>"

     i=i+1

   }

     oWB.close();

   html_code+="</table>"

   ht_v.innerHTML=html_code

   document.getElementById("sumit").value="重新读取"

}

</script>