Front-end html table to generate excel table example-JS Tutorial-php.cn

Home

Web Front-end

JS Tutorial

Front-end html table to generate excel table example

小云云

Feb 08, 2018 pm 01:38 PM

excel html generate

The company recently changed its backend management system. It is required to export ledger items and so on into excel tables. It took me a long time to find it. It is implemented through query.table2excel.js. Forgive me, I don’t know how to do this. Of course, if you have any, you can leave me a message. This article mainly shares with you examples of generating html tables into excel tables. The editor thinks it is quite good, so I will share it with you now and give it as a reference for everyone. Let’s follow the editor to take a look, I hope it can help everyone.

<!DOCTYPE html>
<html>
  <head>
    <meta charset="utf-8" />
    <title></title>
  </head>
  <body>
    <table class="table"> //表格
      <tr class="noExl"> //加class是为了有些你不想导出用来选则
        <th>Header</th>
        <th>111</th>
      </tr>
      <tr>
        <td>Data</td>
        <td>222</td>
      </tr>
    </table>
     
    <button id="btn">导出</button>
     
    <script src="js/jquery-1.11.0.min.js" type="text/javascript" charset="utf-8"></script>//引入jquery
    <script src="js/jquery.table2excel.js" type="text/javascript" charset="utf-8"></script> //引入jquer插件
    <script type="text/javascript">
      $("#btn").click(function(){ //点击按钮执行导出
        $(".table").table2excel({ //选取导出的表格
          exclude: ".noExl", //写你不想都想导出的
          name: "Excel Document Name",
          filename: "项目", //导出的文件名
          exclude_img: true, //是否导出图片
          exclude_links: true,
          exclude_inputs: true
        });
      })
    </script>
     
  </body>
</html>

Copy after login

Related recommendations:

Introduction to several methods of exporting and generating excel tables from php

The above is the detailed content of Front-end html table to generate excel table example. For more information, please follow other related articles on the PHP Chinese website!

Statement of this Website

The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn