js导出table到execl

用js做导出table到execl，兼容不是很好，但这个方法可以，我项目中使用了，另外我参考老外的东西，做了局部改进

<script> var idTmr;          function  getExplorer() {              var explorer = window.navigator.userAgent ;              //ie              if (explorer.indexOf("MSIE") >= 0) {                  return 'ie';              }              //firefox              else if (explorer.indexOf("Firefox") >= 0) {                  return 'Firefox';              }              //Chrome              else if(explorer.indexOf("Chrome") >= 0){                  return 'Chrome';              }              //Opera              else if(explorer.indexOf("Opera") >= 0){                  return 'Opera';              }              //Safari              else if(explorer.indexOf("Safari") >= 0){                  return 'Safari';              }          }          function method5(tableid) {              if(getExplorer()=='ie')              {                  var curTbl = document.getElementById(tableid);                  var oXL = new ActiveXObject("Excel.Application");                  var oWB = oXL.Workbooks.Add();                  var xlsheet = oWB.Worksheets(1);                  var sel = document.body.createTextRange();                  sel.moveToElementText(curTbl);                  sel.select();                  sel.execCommand("Copy");                  xlsheet.Paste();                  oXL.Visible = true;                    try {                      var fname = oXL.Application.GetSaveAsFilename("Excel.xls", "Excel Spreadsheets (*.xls), *.xls");                  } catch (e) {                      print("Nested catch caught " + e);                  } finally {                      oWB.SaveAs(fname);                      oWB.Close(savechanges = false);                      oXL.Quit();                      oXL = null;                      idTmr = window.setInterval("Cleanup();", 1);                  }                }              else              {                  tableToExcel(tabloid,'name','my file.xls')              }          }          function Cleanup() {              window.clearInterval(idTmr);              CollectGarbage();          }          var tableToExcel = (function() {              var uri = 'data:application/vnd.ms-excel;base64,',                      template = '<html><head><meta charset="UTF-8"></head><body><table border="1">{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,filename) {                  if (!table.nodeType) table = document.getElementById(table)                  var ctx = {worksheet: name || 'Worksheet', table: table.innerHTML}                  document.getElementById("dlink").href = uri + base64(format(template, ctx))                  document.getElementById("dlink").download = filename;                document.getElementById("dlink").click();            }          })()</script>

Html中在导出按钮出加一个a标签<a id="dlink" style="display:none"></a>

本站仅提供存储服务，所有内容均由用户发布，如发现有害或侵权内容，请点击举报。