node server app.js
var json2xls = require('json2xls');
app.use(json2xls.middleware);
users.js
res.xls('data.xlsx', list);
list为 json数据
vue前端下载
downExcel(){
var eleLink = document.createElement('a');
eleLink.download = 'a';
eleLink.style.display = 'none';
// 字符内容转变成blob地址
eleLink.href = '/users/excelList';
// 触发点击
document.body.appendChild(eleLink);
eleLink.click();
// 然后移除
document.body.removeChild(eleLink);
}