exceljs 由js数据或者json数据生成一个excel文件

// 个税接收文件提取到excel中
var Excel = require('exceljs'); // 引入模块
var fileData = require("./geshui03"); // 引入相关数据

var workbook = new Excel.Workbook(); // 实例化对象
// 设置工作薄标题
var headData = ["t","k","v","vs","d","f","p","idx","g","r","h","q","checked","group","describe"];
// 循环数据
for (let item in fileData) {
    let sheetName = workbook.addWorksheet(item);  // 添加一个工作薄并命名为item参数
    sheetName.addRow(headData); // 添加首行数据
    let dataAry = fileData[item]["data"];
    // 循环添加每行数据
    for (let index = 0,valAry=[]; index < dataAry.length; index++) {
        val = dataAry[index];
        valAry=[];
        headData.map(function (params) {
            if (typeof val[params] != "undefined") {
                valAry.push(val[params]);
            }else{
                valAry.push("");
            };
        });
        sheetName.addRow(valAry);
    };
};

workbook.xlsx.writeFile('test02.xlsx')
    .then(function(){
        console.log('生成 xlsx');
    });