Estoy tratando de convertir el JSON:
Resultados: console.log(( ${JSON.stringify(results)} );
[ [{"field":"StudentID","value":"A"},{"field":"Total Marks","value":"27853"}],[{"field":"StudentID","value":"B"},{"field":"Total Marks","value":"14337"}],[{"field":"StudentID","value":"C"},{"field":"Total Marks","value":"1324"}],[{"field":"StudentID","value":"D"},{"field":"Total Marks","value":"362"}],[{"field":"StudentID","value":"E"},{"field":"Total Marks","value":"209"}]]a algo un archivo .csv o un archivo de Excel y descárguelo
Student ID Total Marks A 27853 B 14337 C 1324 D 362 E 209¿Alguien podría proporcionar un fragmento del código js que ayudará a implementar esto?
Lo que probé:
const json2csvParser = new Parser(); results.forEach(element => { const csv = json2csvParser.parse(element); console.log(csv); }); const csv = json2csvParser.parse(results); console.log(csv);Esto simplemente se imprime en la consola como:
"field","value" "Student ID","A" "Total Marks","27853" "field","value" "Student ID","B" "Total Marks","14337" "field","value" "Student ID","C" "Total Marks","1324" "field","value" "Student ID","D" "Total Marks","362" "field","value" "Student ID","E" "Total Marks","209"Descargue el paquete csv-parser npm.
npm i -s csv-parserY para descargar;
const fs = require("fs"); fs.writeFileSync("demo.csv", csv); console.log("Done!");Tutorial básico para ejecutar en la página js;
// (A) DATA ARRAY var data = [ ["Alpha", "Beta"], ["Charlie", "Delta"], ["Echo", "Foxtrot"] ]; // (B) WRITE TO FILE const fs = require("fs"); const stream = fs.createWriteStream("demoC.csv"); for (let i of data) { stream.write(i.join(",") + "\r\n"); } stream.end(); console.log("Done!");