node生成excel并发送流文件到前端

var express = require('express');
var router = express.Router();
var xlsx = require('node-xlsx');
var fs = require('fs');
var Task_listSchema = require('../../../model/Task_listSchema');
var sql = require("../../../model/index")
stream = require('stream')

/* GET home page. */

router.get('/', function (req, res) {
    Task_listSchema.find({ "start": { "$gte": req.query.start, "$lte": req.query.end } }, function (err, docs) {
        if (docs.length != 0) {
            let array1 = [];
            let newarr = [];
            let itemarr = ["项目名称", "任务详情", "任务开始时间", "任务结束时间"]
            for (let j = 0; j < docs.length; j++) {
                // array1.push(docs[j].start,docs[j].end)
                array1[0] = docs[j].project_name
                array1[1] = docs[j].task_details
                array1[2] = docs[j].start
                array1[3] = docs[j].end
                newarr.push(array1)
                array1 = []
            }

            var list = [{
                name: docs[0].project_name,
                    data: [
                        itemarr,
                        ...newarr
                ]
            }];
            
            var buffer = xlsx.build(list);
            res.set('Content-Type', 'application/octet-stream;charset=utf-8;');
            res.set("Content-Disposition", `attachment;filename=${encodeURIComponent('结果呢')}.xlsx`);

            // let data = fs.createReadStream(path.join(__dirname, '../../public/ha.xlsx'));
            // buffer.pipe(res)
            let readStream = new stream.PassThrough();
            readStream.end(buffer);
            readStream.pipe(res);

            return;
        } else {
            res.json({
                data: [],
                meta: {
                    msg: "目前没有任务。",
                    status: 417
                }
            })
        }
    });

    // console.log("1221")




})



module.exports = router;