插件地址:
http://excel.wj2015.com/_book/docs/%E5%8A%9F%E8%83%BD%E6%A6%82%E8%A7%88.html
res.data.list.unshift({CreatedAt: '日期', 'user.nickName': '用户', track: '订单号', iata: '目的地', packages: '件数', gross: '毛重', amountReceivable: '费用', amountPayable: '应付'});
// 2. 如果需要调整顺序,请执行梳理函数
var data = layExcel.filterExportData(res.data.list, {
CreatedAt: function(value, line, data) {
if (value == '日期') {
return value;
} else {
return formatTimeToStr(value, "yyyy-MM-dd hh:mm:ss");
}
},
'user.nickName': function(value, line, data) {
if (value == '用户') {
return value;
} else {
if (line.user != undefined) {
return line.user.nickName;
} else {
return '';
}
}
},
track: 'track',
iata: 'iata',
packages: 'packages',
gross: 'gross',
amountReceivable: 'amountReceivable',
amountPayable: 'amountPayable',
});
data.push({
CreatedAt: '',
'user.nickName': '',
track: '',
iata: '',
packages: '',
gross: '',
amountReceivable: this.amountReceivable,
amountPayable: this.amountPayable
});
layExcel.setExportCellStyle(data, 'A1:H1', {
s: {
fill: { bgColor: { rgb: 'b8dee7' }, fgColor: { rgb: 'b8dee7' } },
font: {
color: {
rgb: '000000',
},
sz: '11',
bold: true,
},
border: {
top: { style: 'thin', color: { rgb: 'FF000000' } },
bottom: { style: 'thin', color: { rgb: 'FF000000' } },
left: { style: 'thin', color: { rgb: 'FF000000' } },
right: { style: 'thin', color: { rgb: 'FF000000' } },
},
}
});
layExcel.setExportCellStyle(data, 'A2:H'+data.length, {
s: {
border: {
top: { style: 'thin', color: { rgb: 'FF000000' } },
bottom: { style: 'thin', color: { rgb: 'FF000000' } },
left: { style: 'thin', color: { rgb: 'FF000000' } },
right: { style: 'thin', color: { rgb: 'FF000000' } },
},
}
});
var makeColConfig = layExcel.makeColConfig({
A: 200,
B: 100,
C: 100,
D: 100,
E: 100,
F: 100,
G: 100,
})
// 3. 执行导出函数,系统会弹出弹框
layExcel.expo