所以為了更好的導出excel數據,datatables本身就提供了導出
excel、csv、pdf等格式的功能,參考如下鏈接:/extensions/buttons/examples/html5/excelTextBold.html(官方的例子導出excel,
有源碼和所需的文件):/extensions/buttons/examples/initialisation/export.html(導出csv/pdf/copy/打印)
1.所需的js文件:
//code./jquery-1.12.4.js
/1.10.13/js/jquery.dataTables.min.js
/buttons/1.2.4/js/dataTables.buttons.min.js
//cdnjs./ajax/libs/jszip/2.5.0/jszip.min.js
//cdn./buttons/1.2.4/js/buttons.html5.min.js
$(document).ready(function() {
$('#example').DataTable( {
dom: 'Bfrtip',
"buttons": [
{
'extend': 'excel',
'text': '導出',//定義導出excel按鈕的文字
'exportOptions': {
'modifier': {
'page': 'current'
}
}
}
],
} );
} );
2.所需的css:
/1.10.13/css/jquery.dataTables.min.css
/buttons/1.2.4/css/buttons.dataTables.min.css
3.html代碼:
<table id="example" class="display nowrap" cellspacing="0" width="100%">
<thead>
<tr>
<th>Name</th>
<th>Position</th>
<th>Office</th>
<th>Age</th>
<th>Start date</th>
<th>Salary</th>
</tr>
</thead>
<tfoot>
<tr>
<th>Name</th>
<th>Position</th>
<th>Office</th>
<th>Age</th>
<th>Start date</th>
<th>Salary</th>
</tr>
</tfoot>
<tbody>
<tr>
<td>Tiger Nixon</td>
<td>System Architect</td>
<td>Edinburgh</td>
<td>61</td>
<td>2011/04/25</td>
<td>$320,800</td>
</tr>
<tr>
<td>Garrett Winters</td>
<td>Accountant</td>
<td>Tokyo</td>
<td>63</td>
<td>2011/07/25</td>
<td>$170,750</td>
</tr>
</tbody>
</thead>
</table>