一个不错的能将HTML表格导出为excel,pdf等的jquery插件
https://github.com/kayalshri/tableExport.jquery.plugin
https://github.com/kayalshri/
tableExport.jquery.plugin
Export HTML Table to
- JSON
- XML
- PNG
- CSV
- TXT
- SQL
- MS-Word
- Ms-Excel
- Ms-Powerpoint
Installation
jquery Plugin < script type="text/javascript" src="tableExport.js"> < script type="text/javascript" src="jquery.base64.js">
PNG Export
<script type="text/javascript" src="html2canvas.js">
PDF Export
<script type="text/javascript" src="jspdf/libs/sprintf.js"> < script type="text/javascript" src="jspdf/jspdf.js"> < script type="text/javascript" src="jspdf/libs/base64.js">
Usage
onClick ="$('#tableID').tableExport({type:'pdf',escape:'false'});"
Options
separator: ',' ignoreColumn: [2,3], tableName:'yourTableName' type:'csv' pdfFontSize:14 pdfLeftMargin:20 escape:'true' htmlContent:'false' consoleLog:'false'
<html> <head> <title>Export html table to excel and csv using jquery</title> <script src="/jquery-1.9.1.min.js"></script> <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.0/css/bootstrap.min.css"> <script type="text/javascript" src="/jquery.base64.js"></script>
<script type="text/javascript" src=/tableExport.js"></script> <script type="text/javascript" src="/jspdf/libs/sprintf.js"> </script> <script type="text/javascript" src="http://localhost:8082/myphp/tableExport.jquery.plugin-master/jspdf/jspdf.js"></script> <script type="text/javascript" src="/jspdf/base64.js"></script> </head> <body> [align=right] <br><br><br> <button class="btn btn-success" onClick ="$('#customers').tableExport({type: 'excel', escape: 'false'});">Excel Export</button> <button class="btn btn-success" onClick ="$('#customers').tableExport({type: 'pdf', escape: 'false'});">CSV Export</button> <br><br> [/align] <table id="customers" class="table table-striped table-bordered" > <thead> <tr class='warning'> <th>Country</th> <th>Population</th> <th>Date</th> </tr> </thead> <tbody> <tr> <td>Chinna</td> <td>1,363,480,000</td> <td>March 24, 2014</td> </tr> <tr> <td>India</td> <td>1,241,900,000</td> <td>March 24, 2014</td> </tr> <tr> <td>United States</td> <td>317,746,000</td> <td>March 24, 2014</td> </tr> <tr> <td>Indonesia</td> <td>249,866,000</td> <td>July 1, 2013</td> </tr> <tr> <td>Brazil</td> <td>201,032,714</td> <td>July 1, 2013</td> </tr> </tbody> </table> </div> </body> </html>
