html转换成excel表格导出兼容ie,火狐,谷歌

来源：互联网发布：剑灵龙女九头身数据图编辑：程序博客网时间：2024/06/14 09:45
<!DOCTYPE html>  <html>  <head lang="en">      <meta charset="UTF-8">      <title>html 表格导出道</title>  </head>  <body>  <div>     <button type="button" onclick="excelFn('tableExcel')">导出Excel方法五</button>  </div>  <div id="myDiv">  <table id="tableExcel" width="100%" border="1" cellspacing="0" cellpadding="0">      <tr>          <td colspan="5" align="center">html 表格导出道Excel</td>      </tr>      <tr>          <td>列标题1</td>          <td>列标题2</td>          <td>类标题3</td>          <td>列标题4</td>          <td>列标题5</td>      </tr>      <tr>          <td>aaa</td>          <td>bbb</td>          <td>ccc</td>          <td>ddd</td>          <td>eee</td>      </tr>      <tr>          <td>AAA</td>          <td>BBB</td>          <td>CCC</td>          <td>DDD</td>          <td>EEE</td>      </tr>      <tr>          <td>FFF</td>          <td>GGG</td>          <td>HHH</td>          <td>III</td>          <td>JJJ</td>      </tr>  </table>  </div><script type="text/javascript">       function excelFn(tableid) {          if(window.navigator.userAgent.indexOf("MSIE") >= 0){              window.clipboardData.setData("Text",document.all('tableExcel').outerHTML);try{var ExApp = new ActiveXObject("Excel.Application")var ExWBk = ExApp.workbooks.add()var ExWSh = ExWBk.worksheets(1)ExApp.DisplayAlerts = falseExApp.visible = true}catch(e){alert("您的电脑没有安装Microsoft Excel软件！")return false} ExWBk.worksheets(1).Paste;         }else{              tableToExcel(tableid)          }      }      var tableToExcel = (function() {          var uri = 'data:application/vnd.ms-excel;base64,',                  template = '<html><head><meta charset="UTF-8"></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))          }      })();</script> </body>  </html>
0 0