登 录
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"><br /> <HTML><br /> <HEAD><br /> <TITLE> New Document </TITLE><br /> <META NAME="Generator" CONTENT="EditPlus"><br /> <META NAME="Author" CONTENT=""><br /> <META NAME="Keywords" CONTENT=""><br /> <META NAME="Description" CONTENT=""><br /> </HEAD></p> <p> <BODY><br /> <table id="tableExcel" width="100%" border="1" cellspacing="0" cellpadding="0"></p> <p><tr></p> <p><td colspan="5" align="center">WEB页面导出为EXCEL文档的方法</td></p> <p></tr></p> <p><tr></p> <p><td>列标题1</td></p> <p><td>列标题2</td></p> <p><td>列标题3</td></p> <p><td>列标题4</td></p> <p><td>列标题5</td></p> <p></tr></p> <p><tr></p> <p><td>aaa</td></p> <p><td>bbb</td></p> <p><td>ccc</td></p> <p><td>ddd</td></p> <p><td>eee</td></p> <p></tr></p> <p><tr></p> <p><td>AAA</td></p> <p><td>BBB</td></p> <p><td>CCC</td></p> <p><td>DDD</td></p> <p><td>EEE</td></p> <p></tr></p> <p><tr></p> <p><td>FFF</td></p> <p><td>GGG</td></p> <p><td>HHH</td></p> <p><td>III</td></p> <p><td>JJJ</td></p> <p></tr></p> <p></table><br /> <input type="button" onclick="javascript:method1('tableExcel');" value="第一种方法导入到EXCEL"></p> <p><input type="button" onclick="javascript:method2('tableExcel');" value="第二种方法导入到EXCEL"></p> <p><input type="button" onclick="javascript:getXlsFromTbl('tableExcel',null);" value="第三种方法导入到EXCEL"><br /> <SCRIPT LANGUAGE="javascript"></p> <p>function method1(tableid)<br /> {//整个表格拷贝到EXCEL中</p> <p>var curTbl = document.getElementById(tableid);</p> <p>var oXL = new ActiveXObject("Excel.Application");</p> <p>//创建AX对象excel</p> <p>var oWB = oXL.Workbooks.Add();</p> <p>//获取workbook对象</p> <p>var oSheet = oWB.ActiveSheet;</p> <p>//激活当前sheet</p> <p>var sel = document.body.createTextRange();</p> <p>sel.moveToElementText(curTbl);</p> <p>//把表格中的内容移到TextRange中</p> <p>sel.select();</p> <p>//全选TextRange中内容</p> <p>sel.execCommand("Copy");</p> <p>//复制TextRange中内容</p> <p>oSheet.Paste();</p> <p>//粘贴到活动的EXCEL中</p> <p>oXL.Visible = true;</p> <p>//设置excel可见属性</p> <p>}</p> <p>function method2(tableid) //读取表格中每个单元到EXCEL中<br /> {</p> <p>var curTbl = document.getElementById(tableid);</p> <p>var oXL = new ActiveXObject("Excel.Application");</p> <p>//创建AX对象excel</p> <p>var oWB = oXL.Workbooks.Add();</p> <p>//获取workbook对象</p> <p>var oSheet = oWB.ActiveSheet;</p> <p>//激活当前sheet</p> <p>var Lenr = curTbl.rows.length;</p> <p>//取得表格行数</p> <p>for (i = 0; i < Lenr; i++)</p> <p>{</p> <p>var Lenc = curTbl.rows(i).cells.length;</p> <p>//取得每行的列数</p> <p>for (j = 0; j < Lenc; j++)</p> <p>{</p> <p>oSheet.Cells(i + 1, j + 1).value = curTbl.rows(i).cells(j).innerText;</p> <p>//赋值</p> <p>}</p> <p>}</p> <p>oXL.Visible = true;</p> <p>//设置excel可见属性</p> <p>}</p> <p>function getXlsFromTbl(inTblId, inWindow) {</p> <p>try {</p> <p>var allStr = "";</p> <p>var curStr = "";</p> <p>//alert("getXlsFromTbl");</p> <p>if (inTblId != null && inTblId != "" && inTblId != "null") {</p> <p>curStr = getTblData(inTblId, inWindow);</p> <p>}</p> <p>if (curStr != null) {</p> <p>allStr += curStr;</p> <p>}</p> <p>else {</p> <p>alert("你要导出的表不存在！");</p> <p>return;</p> <p>}</p> <p>var fileName = getExcelFileName();</p> <p>doFileExport(fileName, allStr);</p> <p>}</p> <p>catch(e) {</p> <p>alert("导出发生异常:" + e.name + "->" + e.description + "!");</p> <p>}</p> <p>}<br /> //---------------------------------------------<br /> function getTblData(inTbl, inWindow) {</p> <p>var rows = 0;</p> <p>//alert("getTblData is " + inWindow);</p> <p>var tblDocument = document;</p> <p>if (!!inWindow && inWindow != "") {</p> <p>if (!document.all(inWindow)) {</p> <p>return null;</p> <p>}</p> <p>else {</p> <p>tblDocument = eval(inWindow).document;</p> <p>}</p> <p>}</p> <p>var curTbl = tblDocument.getElementById(inTbl);</p> <p>var outStr = "";</p> <p>if (curTbl != null) {</p> <p>for (var j = 0; j < curTbl.rows.length; j++) {</p> <p>//alert("j is " + j);</p> <p>for (var i = 0; i < curTbl.rows[j].cells.length; i++) {</p> <p>//alert("i is " + i);</p> <p>if (i == 0 && rows > 0) {</p> <p>outStr += " ";</p> <p>rows -= 1;</p> <p>}</p> <p>outStr += curTbl.rows[j].cells[i].innerText + " ";</p> <p>if (curTbl.rows[j].cells[i].colSpan > 1) {</p> <p>for (var k = 0; k < curTbl.rows[j].cells[i].colSpan - 1; k++) {</p> <p>outStr += " ";</p> <p>}</p> <p>}</p> <p>if (i == 0) {</p> <p>if (rows == 0 && curTbl.rows[j].cells[i].rowSpan > 1) {</p> <p>rows = curTbl.rows[j].cells[i].rowSpan - 1;</p> <p>}</p> <p>}</p> <p>}</p> <p>outStr += " ";</p> <p>}</p> <p>}</p> <p>else {</p> <p>outStr = null;</p> <p>alert(inTbl + "不存在!");</p> <p>}</p> <p>return outStr;</p> <p>}</p> <p>function getExcelFileName() {</p> <p>var d = new Date();</p> <p>var curYear = d.getYear();</p> <p>var curMonth = "" + (d.getMonth() + 1);</p> <p>var curDate = "" + d.getDate();</p> <p>var curHour = "" + d.getHours();</p> <p>var curMinute = "" + d.getMinutes();</p> <p>var curSecond = "" + d.getSeconds();</p> <p>if (curMonth.length == 1) {</p> <p>curMonth = "0" + curMonth;</p> <p>}</p> <p>if (curDate.length == 1) {</p> <p>curDate = "0" + curDate;</p> <p>}</p> <p>if (curHour.length == 1) {</p> <p>curHour = "0" + curHour;</p> <p>}</p> <p>if (curMinute.length == 1) {</p> <p>curMinute = "0" + curMinute;</p> <p>}</p> <p>if (curSecond.length == 1) {</p> <p>curSecond = "0" + curSecond;</p> <p>}</p> <p>var fileName = "leo_zhang" + "_" + curYear + curMonth + curDate + "_"</p> <p>+ curHour + curMinute + curSecond + ".csv";</p> <p>//alert(fileName);</p> <p>return fileName;</p> <p>}</p> <p>function doFileExport(inName, inStr) {</p> <p>var xlsWin = null;</p> <p>if (!!document.all("glbHideFrm")) {</p> <p>xlsWin = glbHideFrm;</p> <p>}</p> <p>else {</p> <p>var width = 6;</p> <p>var height = 4;</p> <p>var openPara = "left=" + (window.screen.width / 2 - width / 2)</p> <p>+ ",top=" + (window.screen.height / 2 - height / 2)</p> <p>+ ",scrollbars=no,width=" + width + ",height=" + height;</p> <p>xlsWin = window.open("", "_blank", openPara);</p> <p>}</p> <p>xlsWin.document.write(inStr);</p> <p>xlsWin.document.close();</p> <p>xlsWin.document.execCommand('Saveas', true, inName);</p> <p>xlsWin.close();</p> <p>}<br /> </SCRIPT></p> <p> </BODY><br /> </HTML>
抱歉!评论已关闭.