Home > Article > Web Front-end > Front-end html table to generate excel table example
Front-end html table to generate excel table example
- 小云云Original
- 2018-02-08 13:38:042977browse
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>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!