json导xlxs

var express = require('express');
var dmodel = require('../model/dl');
var router = express.Router();
const fs = require('fs')
const json2xls = require('json2xls');
/* GET home page. */
router.get('/', function(req, res, next) {
  res.render('index', { title: 'Express' });
});
router.get("/xls",(req,res)=>{
  fs.readFile('json(1).json','utf8',(err,data)=>{
    if (err) throw err;
    const json = JSON.parse(data);
    const jsonArray = [];
    json.results.list.forEach(item=>{
      item.replyList.forEach(i=>{
        let temp = {
          '分组名称' : i.groupName,
          '标题' : i.title,
          '内容' : i.content
        }
        jsonArray.push(temp)
      })
    })
    res.json(jsonArray)
    let xls = json2xls(jsonArray);
    fs.writeFileSync('导出test.xlsx', xls, 'binary');
  })
})

module.exports = router;