src/main/webapp/plugin/js/tableExport/test/singleExcel.html

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

<!DOCTYPE html>
<html>

<head>
  <meta charset="UTF-8">
  <title>HTML table Export</title>
  <script type="text/javascript" src="http://code.jquery.com/jquery-latest.min.js"></script>
  <script type="text/javascript" src="../libs/FileSaver/FileSaver.min.js"></script>
  <script type="text/javascript" src="../tableExport.js"></script>
  <style type="text/css">
    <!-- h3 {
      font-size: 1em;
      font-weight: normal;
    }

    .table-striped {
      background-color: white;
    }

    table > thead > tr > td,
    table > thead > tr > th {
      background-color: gray;
      color: white;
    }

    .table-striped > tbody > tr:nth-child(2n+1) > td {
      background-color: #ccdf88;
    }

    .table-striped.numformat > tbody > tr > td {
      text-align: right;
      vertical-align: top;
    }

    .table-striped th.hidden,
    .table-striped td.hidden {
      position: absolute;
      visibility: hidden;
    }

    -->
  </style>

</head>
<body>
  <a href="#" onclick="$('.pvtTable').tableExport({type:'excel', excelstyles:['border-bottom', 'border-top', 'border-left', 'border-right']});">Export to Excel</a>
  <table data-numcols="3" data-numrows="2" class="pvtTable">
    <thead>
      <tr>
        <th></th>
        <th class="pvtColLabel">black</th>
        <th class="pvtColLabel">hisp</th>
        <th class="pvtColLabel">other</th>
        <th class="pvtTotalLabel">Totals</th>
      </tr>
    </thead>
    <tbody>
      <tr>
        <td class="pvtRowLabel">no</td>
        <td data-value="317" class="pvtVal row0 col0">317</td>