Json转Excel

//安装json2excel模块：npm install json2excel
var jexcel = require('json2excel'); //导入模块

var data = {
    sheets: [{
        header: { //标头
            'author': 'authorName',
            'title': 'title',
            'aa':'备注',
        },
        items: [ //行 内容
        {
            author:'john',
            title:'how to use this',
            aa:'cc',
        },
        {
            author:'Bob',
            title: 'so Easy',
            aa:'dd'
        },

        ],
        sheetName: 'sheet1', //表名
    }],
    filepath: 'j2x.xlsx' //文件名
}

jexcel.j2e(data,function(err){
    console.log('finish') //完成打印
});

参考