js 兼容Firefox与IE的Excel到处

最新推荐文章于 2023-04-12 14:42:54 发布

原创最新推荐文章于 2023-04-12 14:42:54 发布 · 1k 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#js-兼容Firef #Excel

项目示例专栏收录该内容

13 篇文章

订阅专栏

本文介绍如何在JavaScript中通过不同的方法将表格数据导出为Excel文件，包括针对IE和Firefox浏览器的处理方式。

            //inTblId  待导出table的ID
             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 {
                     tableToExcelForFirefox('tb', '');
              }
     }

IE下执行

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

FireFox

        var tableToExcelForFirefox = (function () {
            var uri = 'data:application/vnd.ms-excel;base64,'
                , template = '<html xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns="http://www.w3.org/TR/REC-html40"><head><!--[if gte mso 9]><xml><x:ExcelWorkbook><x:ExcelWorksheets><x:ExcelWorksheet><x:Name>{worksheet}</x:Name><x:WorksheetOptions><x:DisplayGridlines/></x:WorksheetOptions></x:ExcelWorksheet></x:ExcelWorksheets></x:ExcelWorkbook></xml><![endif]--></head><body><table>{table}</table></body></html>'
                , base64 = function (s) { return window.btoa(unescape(encodeURIComponent(s))) }
                , format = function (s, c) { return s.replace(/{(\w+)}/g, function (m, p) { return c[p]; }) }
            return function (table, name) {
                if (!table.nodeType) table = document.getElementById(table)
                var ctx = { worksheet: name || 'Worksheet', table: table.innerHTML }
                window.location.href = uri + base64(format(template, ctx))
            }
        })()