日期:2014-05-16  浏览次数:20406 次

js导出table到excel,同时兼容FF和IE
前台调用(第一个参数是table的id): <input value="导出" type="button" /> 
       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 + "不