0
407
ViewsCómo convertir JSON anidado en excel en nodejs
Estoy tratando de convertir el siguiente JSON en Excel, estoy usando XLSX para ello, está convirtiendo mi JSON en Excel, pero la matriz anidada de dailyPointsArray está en blanco después de convertirla en Excel.
Código probado
const XLSX = require("xlsx"); const workSheet = XLSX.utils.json_to_sheet(attendanceData); const workBook = XLSX.utils.book_new(); XLSX.utils.book_append_sheet(workBook, workSheet, "attendance"); XLSX.write(workBook, { bookType: "xlsx", type: "buffer" }); XLSX.write(workBook, { bookType: "xlsx", type: "binary" }); XLSX.writeFile(workBook,"newExcel.xlsx"); attendanceData:[ { workerId: '1230', workerFullName: 'A', workerDepartment: 'INFORMATION TECHNOLOGY', workerDesignation: 'ASSISTANT MANAGER', Location: 'locationA', dailyPointsArray: [ { inTime: '-', Date: '23/03/2022', outTime: '-', Points: null, createdAs: 'ABSENT' }, { inTime: '-', Date: '24/03/2022', outTime: '-', Points: null, createdAs: 'ABSENT' } ], total_duration: 0, total_shift_points: 0 }, { workerId: '1128', workerFullName: 'B', workerDepartment: 'INFORMATION TECHNOLOGY', workerDesignation: 'MANAGER', Location: 'LocationA', dailyPointsArray: [ { inTime: '-', Date: '23/03/2022', outTime: '-', Points: null, createdAs: 'ABSENT' }, { inTime: '-', Date: '24/03/2022', outTime: '-', Points: null, createdAs: 'ABSENT' } ], total_duration: 17, total_shift_points: 2 }, ] A continuación se muestra la salida del archivo de Excel 
Como puede ver, la columna de dailyPointsArray está vacía. Quiero que mi archivo de Excel sea como la imagen de abajo 
·
Juan Pablo Isaza
1 answers
Answer question0
intente aplanar la matriz: filtre la matriz anidada, obtenga las claves que desee, en el orden que desee
prueba esto:
const filtered = attendanceData.map(obj => { // get totals to add them later to keep column order (or use `header` param for columns order) const { dailyPointsArray, total_duration, total_shift_points, ...rest } = obj; // flatten.. dailyPointsArray.map(el => { rest[el['Date']] = el.createdAs; }); return {...rest, total_duration, total_shift_points }; }); const XLSX = require("xlsx"); const workSheet = XLSX.utils.json_to_sheet(filtered); const workBook = XLSX.utils.book_new(); XLSX.utils.book_append_sheet(workBook, workSheet, "attendance"); XLSX.write(workBook, { bookType: "xlsx", type: "buffer" }); XLSX.write(workBook, { bookType: "xlsx", type: "binary" }); XLSX.writeFile(workBook,"newExcel.xlsx");
·
Juan Pablo Isaza
Report
Answer question