js导出table到excel同时兼容FF和IE示例_javascript技巧

前台调用（第一个参数是table的id)： <input value="导出" type="button" /> <BR>function toExcel(inTblId, inWindow) { <BR>if ($.browser.msie) { //如果是IE浏览器 <BR>try { <BR>var allStr = ""; <BR>var curStr = ""; <BR>if (inTblId != null && inTblId != "" && inTblId != "null") { <BR>curStr = getTblData(inTblId, inWindow); <BR>} <BR>if (curStr != null) { <BR>allStr += curStr; <BR>} <BR>else { <BR>alert("你要导出的表不存在！"); <BR>return; <BR>} <BR>var fileName = getExcelFileName(); <BR>doFileExport(fileName, allStr); <BR>} <BR>catch (e) { <BR>alert("导出发生异常:" + e.name + "->" + e.description + "!"); <BR>} <BR>} <BR>else { <BR>window.open('data:application/vnd.ms-excel,' + encodeURIComponent($('div[id$=divGvData]').html())); <BR>e.preventDefault(); <BR>} <BR>} <BR>function getTblData(inTbl, inWindow) { <BR>var rows = 0; <BR>var tblDocument = document; <BR>if (!!inWindow && inWindow != "") { <BR>if (!document.all(inWindow)) { <BR>return null; <BR>} <BR>else { <BR>tblDocument = eval(inWindow).document; <BR>} <BR>} <BR>var curTbl = tblDocument.getElementById(inTbl); <BR>if (curTbl.rows.length > 65000) { <BR>alert('源行数不能大于65000行'); <BR>return false; <BR>} <BR>if (curTbl.rows.length <= 1) { <BR>alert('数据源没有数据'); <BR>return false; <BR>} <BR>var outStr = ""; <BR>if (curTbl != null) { <BR>for (var j = 0; j < curTbl.rows.length; j++) { <BR>for (var i = 0; i < curTbl.rows[j].cells.length; i++) { <BR>if (i == 0 && rows > 0) { <BR>outStr += " \t"; <BR>rows -= 1; <BR>} <BR>var tc = curTbl.rows[j].cells[i]; <BR>if (j > 0 && tc.hasChildNodes() && tc.firstChild.nodeName.toLowerCase() == "input") { <BR>if (tc.firstChild.type.toLowerCase() == "checkbox") { <BR>if (tc.firstChild.checked == true) { <BR>outStr += "是" + "\t"; <BR>} <BR>else { <BR>outStr += "否" + "\t"; <BR>} <BR>} <BR>} <BR>else { <br><br>outStr += " "+curTbl.rows[j].cells[i].innerText + "\t"; <BR>} <BR>if (curTbl.rows[j].cells[i].colSpan > 1) { <BR>for (var k = 0; k < curTbl.rows[j].cells[i].colSpan - 1; k++) { <BR>outStr += " \t"; <BR>} <BR>} <BR>if (i == 0) { <BR>if (rows == 0 && curTbl.rows[j].cells[i].rowSpan > 1) { <BR>rows = curTbl.rows[j].cells[i].rowSpan - 1; <BR>} <BR>} <BR>} <BR>outStr += "\r\n"; <BR>} <BR>} <BR>else { <BR>outStr = null; <BR>alert(inTbl + "不存在!"); <BR>} <BR>return outStr; <BR>} <BR>function getExcelFileName() { <BR>var d = new Date(); <BR>var curYear = d.getYear(); <BR>var curMonth = "" + (d.getMonth() + 1); <BR>var curDate = "" + d.getDate(); <BR>var curHour = "" + d.getHours(); <BR>var curMinute = "" + d.getMinutes(); <BR>var curSecond = "" + d.getSeconds(); <BR>if (curMonth.length == 1) { <BR>curMonth = "0" + curMonth; <BR>} <BR>if (curDate.length == 1) { <BR>curDate = "0" + curDate; <BR>} <BR>if (curHour.length == 1) { <BR>curHour = "0" + curHour; <BR>} <BR>if (curMinute.length == 1) { <BR>curMinute = "0" + curMinute; <BR>} <BR>if (curSecond.length == 1) { <BR>curSecond = "0" + curSecond; <BR>} <BR>var fileName = "设备状态" + curYear + curMonth + curDate + curHour + curMinute + curSecond + ".xls"; <BR>return fileName; <BR>} <BR>function doFileExport(inName, inStr) { <BR>var xlsWin = null; <BR>if (!!document.all("glbHideFrm")) { <BR>xlsWin = glbHideFrm; <BR>} <BR>else { <BR>var width = 1; <BR>var height = 1; <BR>var openPara = "left=" + (window.screen.width / 2 + width / 2) <BR>+ ",top=" + (window.screen.height + height / 2) <BR>+ ",scrollbars=no,width=" + width + ",height=" + height; <BR>xlsWin = window.open("", "_blank", openPara); <BR>} <BR>xlsWin.document.write(inStr); <BR>xlsWin.document.close(); <BR>xlsWin.document.execCommand('Saveas', true, inName); <BR>xlsWin.close(); <BR>}