很好用的excel导出插件,可直接导出页面中数据,简单好用。原table2excel.js 使用火狐 ie导出excel有问题,js代码已修改。
html示例代码
<!DOCTYPE html>
<html>
<head lang="en">
<meta charset="UTF-8">
<title>html 表格导出</title>
<script src="https://code.jquery.com/jquery-3.2.1.min.js"></script>
<script src="js/table2excel.js"></script>
<script language="JavaScript" type="text/javascript">
function ExportToExcel() {
$("#tableExcel").table2excel({
exclude : ".noExl", //过滤位置的 css 类名
filename : "表格导出", //文件名称
name: "Excel Document Name.xlsx",
exclude_img: false,//是否导出图片 false导出
exclude_links: true,//是否导出链接 false导出
exclude_inputs: true//是否导出输入框的值 true导出
});
}
</script>
</head>
<body>
<div >
<button type="button" id="btnExport" onclick="ExportToExcel();">导出Excel</button>
</div>
<div id="myDiv">
<table id="tableExcel" width="100%" border="1" cellspacing="0" cellpadding="0">
<tr>
<td colspan="5" align="center">html 表格导出道Excel</td>
</tr>
<tr class="noExl">
<td>列标题1</td>
<td>列标题2</td>
<td>类标题3</td>
<td>列标题4</td>
<td>列标题5</td>
</tr>
<tr>
<td>aaa</td>
<td colspan="2">bbb</td>
<td>ccc</td>
<td>ddd</td>
</tr>
<tr>
<td>AAA</td>
<td>BBB</td>
<td>CCC</td>
<td>DDD</td>
<td><img style="width:200px;height:100px;" src="https://timgsa.baidu.com/timg?image&quality=80&size=b9999_10000&sec=1567590599238&di=d40bd847b484928546834655082e2661&imgtype=0&src=http%3A%2F%2Fwww.people.com.cn%2Fmediafile%2Fpic%2F20150410%2F49%2F9957689516127313013.jpg" /></td>
</tr>
<tr>
<td>FFF</td>
<td>GGG</td>
<td>HHH</td>
<td>III</td>
<td><img style="width:200px;height:100px;" src="https://ss0.bdstatic.com/94oJfD_bAAcT8t7mm9GUKT-xh_/timg?image&quality=100&size=b4000_4000&sec=1567580628&di=6ae2939c4630f67114ee4c7084a6ce2e&src=http://n.sinaimg.cn/front/310/w640h470/20190208/4wav-hsqyiwu4356840.jpg"/></td>
</tr>
</table>
</div>
</body>
</html>