123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117 |
- <!DOCTYPE html>
- <html>
- <head>
- <meta charset="UTF-8">
- <title>HTML table Export</title>
- <script src="https://code.jquery.com/jquery-3.2.1.min.js"></script>
- <script type="text/javascript" src="../libs/js-xlsx/xlsx.core.min.js"></script>
- <script type="text/javascript" src="../libs/FileSaver/FileSaver.min.js"></script>
- <script type="text/javascript" src="../tableExport.js"></script>
- </head>
- <body>
- <section>
- <h1>
- HTML Table Export<br>
- </h1>
- </section>
- <section>
- <ul>
- <li><a href="#" onClick="$('#countries').tableExport({type: 'excel', mso: {fileFormat: 'xlsx'}});"> <img src='icons/xls.png' alt="XLSX" style="width:24px"> XLSX</a></li>
- </ul>
- <table id="countries">
- <thead>
- <tr>
- <th data-field="rank">Rank</th>
- <th data-field="country">Country</th>
- <th data-field="population">Population</th>
- <th data-field="date">Date</th>
- <th data-field="world">% of world</th>
- <th data-field="language">Language</th>
- </tr>
- </thead>
- <tbody>
- <tr>
- <td>1</td>
- <td>China</td>
- <td>1,368,710,000</td>
- <td>March 14, 2015</td>
- <td>18.9%</td>
- <td>中文</td>
- </tr>
- <tr>
- <td>2</td>
- <td>India</td>
- <td>1,268,220,000</td>
- <td>March 14, 2015</td>
- <td>17.5%</td>
- <td>हिन्दी</td>
- </tr>
- <tr>
- <td>3</td>
- <td>United States</td>
- <td>320,583,000</td>
- <td>March 14, 2015</td>
- <td>4.43%</td>
- <td>English</td>
- </tr>
- <tr>
- <td>4</td>
- <td>Indonesia</td>
- <td>255,461,700</td>
- <td>July 1, 2015</td>
- <td>3.53%</td>
- <td></td>
- </tr>
- <tr>
- <td>5</td>
- <td>Brazil</td>
- <td>204,014,000</td>
- <td>March 14, 2015</td>
- <td>2.82%</td>
- <td></td>
- </tr>
- <tr>
- <td>6</td>
- <td>Pakistan</td>
- <td>189,223,000</td>
- <td>March 14, 2015</td>
- <td>2.62%</td>
- <td></td>
- </tr>
- <tr>
- <td>7</td>
- <td>Nigeria</td>
- <td>183,523,000</td>
- <td>July 1, 2015</td>
- <td>2.54%</td>
- <td></td>
- </tr>
- <tr>
- <td>8</td>
- <td>Bangladesh</td>
- <td>157,986,000</td>
- <td>March 14, 2015</td>
- <td>2.18%</td>
- <td></td>
- </tr>
- <tr>
- <td>9</td>
- <td>Russia</td>
- <td>146,270,033</td>
- <td>January 1, 2015</td>
- <td>2.02%</td>
- <td>Русский</td>
- </tr>
- <tr>
- <td>10</td>
- <td>Japan</td>
- <td>126,970,000</td>
- <td>February 1, 2015</td>
- <td>1.76%</td>
- <td>日本語</td>
- </tr>
- </tbody>
- </table>
- </section>
- </body>
- </html>
|