參考https://blog.csdn.net/liuyaqi1993/article/details/78275396
- 文件流導(dǎo)出excel
重點(diǎn)：Content-Disposition 文件名是中文顯示
const nodeExcel = require('node-xlsx');
const urlencode = require('urlencode');
function exportList(ctx, config, listData, excelName) {
let excelConfig = [];
excelConfig.push(config.map(item => {
return item.title
}))
listData.forEach(list => {
excelConfig.push(config.map(item => {
const value = list[item.name];
// 不一定要有value刮吧， 因?yàn)榭赡苁亲杂山M合的value
return item.format && item.format(value, list) || value;
}))
})
let buffer = nodeExcel.build([{name: excelName, data: excelConfig}]);
ctx.set('Content-Type', 'application/octet-stream');
// ctx.request.headers['user-agent']
let name = urlencode(excelName + '_' + (+new Date()) + '.xlsx', "utf-8");
ctx.set("Content-Disposition", "attachment; filename* = UTF-8''"+name);
// ctx.set("Content-Disposition", "attachment; filename="+ (+new Date()) + '.xlsx');
ctx.body = buffer;
}
module.exports = {
exportList: exportList
}
// config 格式
const config = [{
name: 'userid',
title: '用戶ID',
},{
name: 'up_time',
title: '狀態(tài)時(shí)間',
format: function(value) {
return value.replace(/\.\d+/, '');
}
},{
name: 'appl_status_byhand',
// name: 'appl_status_byhand_desc',
title: '人審狀態(tài)',
format: function(value) {
return value && manualStatus[value] && manualStatus[value].text || '-'
}
},{
name: 'available_quota/credit_quota',
title: '剩余額度/授信額度',
format: function(value, item) {
return `￥${item.available_quota/100 || 0}/￥${item.credit_quota/100 || 0}`
}
},{
name: 'user_type_desc',
title: '名單類型',
format: function(value, item) {
if(item.user_type) {
item.user_type.forEach(user => {
userTypeText.push(user_type_define[user] || '-');
});
return userTypeText.join('|');
} else {
return '';
}
}
}]
