<div class="layui-btn-group">
<button id="Button1" onclick="exportTable()" type="button" class="layui-btn">导出</button>
</div>
//导出
function exportTable() {
// 获取头部和body
var data = LAY_EXCEL.tableToJson(document.getElementById(‘LAY-EXPORT-TEST‘)) // 或者 $(‘#LAY-EXPORT-TEST‘)
// console.log(data)
var exportData = []
exportData.push.apply(exportData, data.head)
exportData.push.apply(exportData, data.body)
// console.log(exportData)
LAY_EXCEL.exportExcel(exportData, ‘表格导出.xlsx‘, ‘xlsx‘)
}
原文：https://www.cnblogs.com/P-Z-1/p/13199755.html