html页面表格导出到excel总结 ,html页面表格导出到excel总结.docx

html页面表格导出到excel总结

html页面表格导出到excel总结最近一个项目需要把报表的表格导入excel，在网上找了一些方法，比较研究了一下，记在这里，备忘。表格例子如下：html 表格导出道Exceltd>tr> 列标题1td> 列标题2td> 类标题3td> 列标题4td> 列标题5td>tr> aaatd> bbbtd> ccctd> dddtd> eeetd>tr> AAAtd> BBBtd> CCCtd> DDDtd> EEEtd>tr> FFFtd> GGGtd> HHHtd> IIItd> JJJtd>tr>table>1、js的方法A、将整个表格拷贝到EXCEL中function method1(tableid) {var curTbl = document.getElementById(tableid);var oXL = new ActiveXObject("Excel.Application");var oWB = oXL.Workbooks.Add();var oSheet = oWB.ActiveSheet;var sel = document.body.createTextRange(); sel.moveToElementText(curTbl); sel.select(); sel.execCommand("Copy"); oSheet.Paste(); oXL.Visible = true;}B、读取表格中每个单元到EXCEL中：function method2(tableid){ var curTbl = document.getElementById(tableid); var oXL = new ActiveXObject("Excel.Application"); var oWB = oXL.Workbooks.Add(); var oSheet = oWB.ActiveSheet; 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;}c、把表格输出到另一个页面，然后存成cvs格式function getXlsFromTbl(inTblId, inWindow){try {var allStr = "";var curStr = "";if (inTblId != null && inTblId != "" && inTblId != "null") { curStr = getTblData(inTblId, inWindow); }if (curStr != null) { allStr += curStr; }else {alert("你要导出的表不存在");return; }var fileName = getExcelFileName(); doFileExport(fileName, allStr); }catch(e) {alert("导出发生异常:" + + "->" + e.description + "!"); }}function getTblData(inTbl, inWindow) {var rows = 0;var tblDocument = d