<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=gb2312"> <title>WEB页?面?导?出?为?EXCEL文?档?的?方?法?</title> </head> <body> <table id="tableExcel" width="100%" border="1" cellspacing="0" cellpadding="0"> <tr> <td colspan="5" align="center"> WEB页?面?导?出?为?EXCEL文?档?的?方?法? </td> </tr> <tr> <td> 列?标?题? </td> <td> 列?标?题? </td> <td> 列?标?题? </td> <td> 列?标?题? </td> <td> 列?标?题? </td> </tr> <tr> <td> aaa </td> <td> bbb </td> <td> ccc </td> <td> ddd </td> <td> eee </td> </tr> <tr> <td> AAA </td> <td> BBB </td> <td> CCC </td> <td> DDD </td> <td> EEE </td> </tr> <tr> <td> FFF </td> <td> GGG </td> <td> HHH </td> <td> III </td> <td> JJJ </td> </tr> </table> <input type="button" onclick="javascript:method1('tableExcel');" value="第?一?种?方?法?导?入?到?EXCEL"> <input type="button" onclick="javascript:method2('tableExcel');" value="第?二?种?方?法?导?入?到?EXCEL"> <input type="button" onclick="javascript:getXlsFromTbl('tableExcel',null);" value="第?三?种?方?法?导?入?到?EXCEL"> <script language="javascript"> function method1(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 sel = document.body.createTextRange(); sel.moveToElementText(curTbl); //把?表?格?中?的?内?容?移?到?TextRange中? sel.select(); //全?选?TextRange中?内?容? sel.execCommand("Copy"); //复?制?TextRange中?内?容? oSheet.Paste(); //粘?贴?到?活?动?的?EXCEL中? oXL.Visible = true; //设?置?excel可?见?属?性? } function method2(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可?见?属?性? } 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.name + "->" + e.description + "!"); } } function getTblData(inTbl, inWindow) { var rows = 0; var tblDocument = document; if (!!inWindow && inWindow != "") { if (!document.all(inWindow)) { return null; } else { tblDocument = eval(inWindow).document; } } var curTbl = tblDocument.getElementById(inTbl); var outStr = ""; if (curTbl != null) { for (var j = 0; j < curTbl.rows.length; j++) { for (var i = 0; i < curTbl.rows[j].cells.length; i++) { if (i == 0 && rows > 0) { outStr += " \t"; rows -= 1; } outStr += curTbl.rows[j].cells[i].innerText + "\t"; if (curTbl.rows[j].cells[i].colSpan > 1) { for (var k = 0; k < curTbl.rows[j].cells[i].colSpan - 1; k++) { outStr += " \t"; } } if (i == 0) { if (rows == 0 && curTbl.rows[j].cells[i].rowSpan > 1) { rows = curTbl.rows[j].cells[i].rowSpan - 1; } } } outStr += "\r\n"; } } else { outStr = null; alert(inTbl + "不?存?在?!"); } return outStr; } function getExcelFileName() { var d = new Date(); var curYear = d.getYear(); var curMonth = "" + (d.getMonth() + 1); var curDate = "" + d.getDate(); var curHour = "" + d.getHours(); var curMinute = "" + d.getMinutes(); var curSecond = "" + d.getSeconds(); if (curMonth.length == 1) { curMonth = "0" + curMonth; } if (curDate.length == 1) { curDate = "0" + curDate; } if (curHour.length == 1) { curHour = "0" + curHour; } if (curMinute.length == 1) { curMinute = "0" + curMinute; } if (curSecond.length == 1) { curSecond = "0" + curSecond; } var fileName = "leo_zhang" + "_" + curYear + curMonth + curDate + "_" + curHour + curMinute + curSecond + ".csv"; return fileName; } function doFileExport(inName, inStr) { var xlsWin = null; if (!!document.all("glbHideFrm")) { xlsWin = glbHideFrm; } else { var width = 6; var height = 4; var openPara = "left=" + (window.screen.width / 2 - width / 2) + ",top=" + (window.screen.height / 2 - height / 2) + ",scrollbars=no,width=" + width + ",height=" + height; xlsWin = window.open("", "_blank", openPara); } xlsWin.document.write(inStr); xlsWin.document.close(); xlsWin.document.execCommand('Saveas', true, inName); xlsWin.close(); } </script> </body> </html>
转载于:https://www.cnblogs.com/SissyNong/archive/2009/10/26/1589943.html