Hello World

来源：互联网发布：网络转串口调度器编辑：程序博客网时间：2024/05/22 12:06

在IE下将table标签的内容转换成excel

<!DOCTYPE html><html lang="en"><head>     <meta http-equiv="Content-Type" content="text/html; charset=utf-8"/>     <title>WEB页面导出为EXCEL文档的方法</title> </head> <body>   <table id="tableExcel" width="100%" border="1" cellspacing="0" cellpadding="0">    <thead>    <tr>    <td>ID</td>    <td >模型Name</td>    <td >模型ID</td>    <td>方位角</td>    <td>X</td>    <td>Y</td>    </tr>    </thead>    <tbody>     <tr>    <td>1</td>    <td >12</td>    <td >212</td>    <td>222</td>    <td>333</td>    <td>444</td>    </tr>    </tbody>    </table><input type="button" onclick="javascript:tableToExcel('tableExcel');" value="导入到EXCEL"><script>function tableToExcel(tableid) //读取表格中每个单元到EXCEL中 {     var curTbl = document.getElementById(tableid);     var oXL = new ActiveXObject("Excel.Application");     //创建AX对象excel     var oWB = oXL.Workbooks.Add();     //获取workbook对象     var oSheet = oWB.ActiveSheet;     //激活当前sheet     var Lenr = curTbl.rows.length;     //取得表格行数     for (i = 0; i < Lenr; i++)     {        var Lenc = curTbl.rows(i).cells.length;         //取得每行的列数         for (j = 0; j < Lenc; j++)         {             oSheet.Cells(i + 1, j + 1).value = curTbl.rows(i).cells(j).innerText;             //赋值         }     }     oXL.Visible = true;     //设置excel可见属性 } </script></body> </html>

阅读全文

0 0