欢迎您访问程序员文章站本站旨在为大家提供分享程序员计算机编程知识!
您现在的位置是: 首页

JavaScript实现导出为Excel

程序员文章站 2022-07-13 13:09:40
...
JavaScript实现导出为Excel
用js实现导出页面中的table成excel,网上相关的很多,但是大都多直接用excel打开,需要用户自己另存的,而这段js是直接选择另存为excel,刚好是我需要的,(不合适页面有分页的)

<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>EB页面导出为EXCEL文档的方法</title>
<script type="text/javascript">
<!-- download
function saveCode(obj) {
          var winname = window.open('', '_blank', 'top=10000');
          var strHTML = document.all.tableExcel.innerHTML;
          winname.document.open('text/html', 'replace');
          winname.document.writeln(strHTML);
          winname.document.execCommand('saveas','','excel.xls');
          winname.close();
}
-->
</script>
</head>

<body>
<div id="tableExcel"> 
<table id="test" width="100%" border="1" cellspacing="0" cellpadding="0">
      <tr>
          <td colspan="5" align="center">WEB页面导出为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>
      <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 colspan="5">FFFGGGHHHIIIJJJ</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 rowspan="4">CCCHHHcccccc</td>
        <td>DDD</td>
        <td>EEE</td>
      </tr>
      <tr>
        <td>FFF</td>
        <td>GGG</td>
        <td>III</td>
        <td>JJJ</td>
      </tr>
    
      <tr>
        <td>aaa</td>
        <td>bbb</td>
        <td>ddd</td>
        <td>eee</td>
      </tr>
      <tr>
        <td>aaa</td>
        <td>bbb</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>
<input type="button" value="另存为 Excel" onclick="saveCode(tableExcel)">
</body>
</html>