表格占用铺满整个div
css:
table {width:100%;
table-layout: fixed;
}
统计table行数
var x = $("#table1").find("tr").length;
设置表格第一列
css:
.col_1{
width:80px;
}
js:
$('table').find('td').each(function (i) {
if (i % 11 == 0) {
$(this).addClass('col_1');
}})
导出表格到excel
先下载插件table2excel
添加插件到js,添加按钮调用exportexcel方法:
<script src="./jquery-table2excel-master/src/jquery.table2excel.js"></script>
function exportexcel() {
$("#table1").table2excel({
exclude: ".noExl",//导出所有类名不为noExl的行
name: "Excel Document Name",
filename: "myFileName",
exclude_img: true,
exclude_links: true,
exclude_inputs: true
});}