// 个税接收文件提取到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');
});