layui表格引用excel.js导出全部数据

最近用到layui框架，但在涉及表格导出数据时，却发现自带的导出功能发现只能导出当前页，这时候就需要用到第三方插件excel.js。

导出Excel

这是我用到的表格数据

layui.use(‘table’, function () {
var table = layui.table;
var DateTimeStart = $("#DateTimeStart").val() == “” ? null : $("#DateTimeStart").val();
var DateTimeEnd = $("#DateTimeEnd").val() == “” ? null : $("#DateTimeEnd").val();
var Shift = $("#Shift").val() == “” ? null : $("#Shift").val();
var Crew = $("#Crew").val() == “” ? null : $("#Crew").val();
table.render({
elem: ‘#test’
, url: ‘…/ashx/Handler_Search_scjx.ashx?dateTimeStart=’ + DateTimeStart + ‘&dateTimeEnd=’ + DateTimeEnd + ‘&shift=’ + Shift + ‘&crew=’ + Crew + ‘’
, cols: [[
{ width: ‘10%’, field: ‘Plan_Date’, title: ‘日期’, sort: true }
, { width: ‘7%’, field: ‘Shift_Name’, title: ‘班次’, edit: ‘text’, sort: true }
, { width: ‘7%’, field: ‘Shift_ClassName’, title: ‘班组’, edit: ‘text’, sort: true }
, { width: ‘7%’, field: ‘Equip_name’, title: ‘机台’, sort: true }
, { width: ‘15.6%’, field: ‘Mater_Name’, title: ‘规格’, edit: ‘text’, sort: true }
, { width: ‘8%’, field: ‘Serial_Sum’, title: ‘车数’, edit: ‘text’, sort: true }
, { width: ‘10%’, field: ‘Done_AllRtime’, title: ‘台时(S)’, edit: ‘text’, sort: true }
, { width: ‘12%’, field: ‘Change_time’, title: ‘换料时间(S)’, edit: ‘text’, sort: true }
, { width: ‘12%’, field: ‘Bwb_Time’, title: ‘间隔时间(S)’, edit: ‘text’, sort: true }
, { field: ‘Poly_DisTime’, title: ‘进胶时间(S)’, edit: ‘text’, sort: true }
]]
, limit: 12//一页能够显示的最大数目
// , method: ‘post’
, page: true
, id: ‘test’
});
});
}

导出数据时

$(’#exportExcel’).on(‘click’, function () {
var DateTimeStart = $("#DateTimeStart").val() == “” ? null : $("#DateTimeStart").val();
var DateTimeEnd = $("#DateTimeEnd").val() == “” ? null : $("#DateTimeEnd").val();
var Shift = $("#Shift").val() == “” ? null : $("#Shift").val();
var Crew = $("#Crew").val() == “” ? null : $("#Crew").val();
// alert(“DateTime:” + DateTime + “Shift:” + Shift + “Crew:” + Crew);
$.ajax({
url: ‘…/ashx/Handler_Search_scjx.ashx?type=export&dateTimeStart=’ + DateTimeStart + ‘&dateTimeEnd=’ + DateTimeEnd + ‘&shift=’ + Shift + ‘&crew=’ + Crew + ‘’
, dataType: ‘json’
, contentType: “text/plain”
, success: function (result) {
var data = eval(result.data);
// alert(data.length);
// 1. 数组头部新增表头
result.data.unshift({ Plan_Date: “日期”, Shift_Name: ‘班次’, Shift_ClassName: “班组”, Equip_name: “机台”, Mater_Name: “规格”, Serial_Sum: ‘车数’, Done_AllRtime: “台时(S)”, Change_time: “换料时间(S)”, Bwb_Time: ‘间隔时间(S)’, Poly_DisTime: “进胶时间(S)” });
// 2. 如果需要调整顺序，请执行梳理函数
var data = LAY_EXCEL.filterExportData(result.data, [
‘Plan_Date’,
‘Shift_Name’,
‘Shift_ClassName’,
‘Equip_name’,
‘Mater_Name’,
‘Serial_Sum’,
‘Done_AllRtime’,
‘Change_time’,
‘Bwb_Time’,
‘Poly_DisTime’,
]);
// 3. 执行导出函数，系统会弹出弹框
LAY_EXCEL.exportExcel(data, ‘生产绩效数据.xlsx’, ‘xlsx’);
}
});
});

这是我个人使用过的一个小实例，具体格式和数据可以根据个人需求变动。