默认开启,下拉菜单默认有excel导出当前页配置
可以通过配置 excel.on: false 关掉导出功能
<table id="myTable" lay-filter="myTable"></table>
<script>
layui.use(['form', 'table','soulTable'], function () {
var table = layui.table,
soulTable = layui.soulTable;
var myTable = table.render({
elem: '#myTable'
,url: 'data-1.json'
,toolbar: '<div><a class="layui-btn layui-btn-sm" lay-event="exportExcel">导出</a></div>'
,height: 500
,page: false
,cols: [[
{type: 'numbers', title: '<div style="color: red">序号</div>', fixed: 'left'},
{field: 'title', title: '诗词', width: 200, sort: true},
{field: 'dynasty', title: '朝代', width: 100, sort: true},
{field: 'author', title: '作者', width: 165 },
{field: 'content', title: '内容', width: 123},
{field: 'type', title: '类型', width: 112, sort:true},
{field: 'heat', title: '点赞数', width: 112, fixed: 'right', sort:true},
{field: 'createTime', title: '录入时间', width: 165, fixed: 'right'},
]]
,done: function () {
soulTable.render(this)
}
});
table.on('toolbar(myTable)', function(data) {
if (data.event === 'exportExcel') {
soulTable.export(myTable);
}
})
})
</script>