node json转xlsx文件

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);
}