【JS】导出table到excel，同时兼容FF和IE

提示：扫一扫查出行
【扫一扫了解最新限行尾号】
复制提示

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html>

<head>

<script src="~/Scripts/jquery-1.8.2.js"></script>

      <script type="text/javascript">

        function toExcel(inTblId, inWindow) {

            if ($.browser.msie) { //如果是IE浏览器

                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 + "!");

                }

            } else {

                window.open('data:application/vnd.ms-excel,' + encodeURIComponent($('div[id$=divGvData]').html()));

                e.preventDefault();

            }

        }

 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);

            if (curTbl.rows.length > 65000) {

                alert('源行数不能大于65000行');

                return false;

            }

            if (curTbl.rows.length <= 1) {

                alert('数据源没有数据');

                return false;

            }

            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;

                        }

                        var tc = curTbl.rows[j].cells[i];

                        if (j > 0 && tc.hasChildNodes() && tc.firstChild.nodeName.toLowerCase() == "input") {

                            if (tc.firstChild.type.toLowerCase() == "checkbox") {

                                if (tc.firstChild.checked == true) {

                                    outStr += "是" + "\t";

                                } else {

                                    outStr += "否" + "\t";

                                }

                            }

                        } else {

                            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 = "设备状态" + curYear + curMonth + curDate + curHour + curMinute + curSecond + ".xls";

            return fileName;

        }

        function doFileExport(inName, inStr) {

            var xlsWin = null;

            if (!!document.all("glbHideFrm")) {

                xlsWin = glbHideFrm;

            } else {

                var width = 1; var height = 1;

                var openPara = "left=" + (window.screen.width / 2 + width / 2) + ",top=" + (window.screen.height + 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>

</head>

<body>

    <input value="导出" type="button" onclick="toExcel('tb','')" />

    <table id="tb">

        <tr>

            <td>

            </td>

        </tr>

    </table>

    前台调用（第一个参数是table的id)：

    <input value="导出" type="button" onclick="toExcel('tb','')" />

</body>

</html>