首页 > 代码库 > js导出到excel 兼容ie11火狐，谷歌，360
js导出到excel 兼容ie11火狐，谷歌，360
<script language="javascript" type="text/javascript"> function isIE() { //ie? if (!!window.ActiveXObject || "ActiveXObject" in window) return true; else return false; } function getXlsFromTbl(inTblId, inWindow) { try { var allStr = ""; var curStr = ""; var fileName = getExcelFileName(); // var cc = document.all; // var ccc = typeof (document.all) // alert(cc) // alert(ccc) if (inTblId != null && inTblId != "" && inTblId != "null") { var hh = isIE(); if (hh == true) //IE浏览器 { curStr = getTblData(inTblId, inWindow); if (curStr != null) { allStr += curStr; } else { alert("你要导出的表不存在！"); return; } doFileExport(fileName, allStr); } else { curStr = getTblData1(inTblId, inWindow); if (curStr != null) { allStr += curStr; } else { alert("你要导出的表不存在！"); return; } var uri = ‘data:text/xls;charset=utf-8,\ufeff‘ + encodeURIComponent(allStr); //创建a标签模拟点击下载 var downloadLink = document.createElement("a"); downloadLink.href = http://www.mamicode.com/uri; downloadLink.download = fileName; document.body.appendChild(downloadLink); downloadLink.click(); document.body.removeChild(downloadLink); } } } catch (e) { alert("导出发生异常:" + e.name + "->" + e.description + "!"); } } function getTblData(inTbl, inWindow) { var rows = 0; //alert("getTblData is " + inWindow); 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++) { //alert("j is " + j); for (var i = 0; i < curTbl.rows[j].cells.length; i++) { //alert("i is " + i); if (i == 0 && rows > 0) { outStr += " \t"; rows -= 1; } outStr += curTbl.rows[j].cells[i].innerHTML + " \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 getTblData1(inTbl, inWindow) { var rows = 0; var tblDocument = document; //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].innerHTML + ","; //\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 = "百度一下你就知道" + "_" + curYear + curMonth + curDate + "_" + curHour + curMinute + curSecond + ".xls"; //alert(fileName); 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>
js导出到excel 兼容ie11火狐，谷歌，360