JavaScript导出Excel类

  1. var ExcelHelper = {};
  2. ExcelHelper.getBrowserName = function() {
  3.     var ua = window.navigator.userAgent;
  4.     //ie 
  5.     if (ua.indexOf("MSIE") >= 0) {
  6.         return 'ie';
  7.     }
  8.     //firefox 
  9.     else if (ua.indexOf("Firefox") >= 0) {
  10.         return 'Firefox';
  11.     }
  12.     //Chrome
  13.     else if (ua.indexOf("Chrome") >= 0) {
  14.         return 'Chrome';
  15.     }
  16.     //Opera
  17.     else if (ua.indexOf("Opera") >= 0) {
  18.         return 'Opera';
  19.     }
  20.     //Safari
  21.     else if (ua.indexOf("Safari") >= 0) {
  22.         return 'Safari';
  23.     }
  24. }
  26. ExcelHelper.tableToExcel = (function() {
  27.     var uri = 'data:application/vnd.ms-excel;base64,',
  28.         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>',
  29.         base64 = function(s) {
  30.             return window.btoa(unescape(encodeURIComponent(s)))
  31.         },
  32.         format = function(s, c) {
  33.             return s.replace(/{(\w+)}/g,
  34.                 function(m, p) {
  35.                     return c[p];
  36.                 })
  37.         }
  39.     return function(table, name) {
  40.         var ctx = {
  41.             "worksheet": name || 'Worksheet',
  42.             table: table.innerHTML
  43.         }
  44.         window.location.href = uri + base64(format(template, ctx))
  45.     }
  46. })();
  49. ExcelHelper.CreateExcelByTable = function(table) {
  50.     var bn = this.getBrowserName();
  51.     if (bn == "ie") {
  52.         var ax = new ActiveXObject("Excel.Application");
  53.         var wb = ax.Workbooks.Add();
  54.         var sheet = wb.Worksheets(1);
  56.         var tr = document.body.createTextRange();
  57.         tr.moveToElementText(table);
  58.         tr.select();
  59.         tr.execCommand("Copy");
  60.         sheet.Paste();
  62.         ax.Visible = true;
  64.         var si = null;
  66.         var cleanup = function() {
  67.             if (si) {
  68.                 window.clearInterval(si);
  69.             }
  70.         }
  72.         try {
  73.             var fname = ax.Application.GetSaveAsFilename("Excel.xls", "Excel Spreadsheets (*.xls), *.xls");
  74.         } catch (e) {
  75.             print("Nested catch caught " + e);
  76.         } finally {
  77.             wb.SaveAs(fname);
  78.             var savechanges = false;
  79.             wb.Close(savechanges);
  81.             ax.Quit();
  82.             ax = null;
  84.             si = window.setInterval(cleanup, 1);
  85.         }
  86.     } else {
  87.         this.tableToExcel(table);
  88.     }
  89. }

测试代码

  1. var table = document.getElementById('table_id');
  2. ExcelHelper.CreateExcelByTable(table);