Node.js Tutorial to Export JSON File to Microsoft Excel (XLSX) File Using xlsx Library in Terminal

npm i xlsx

index.js

const xlsx = require('xlsx');
const fs = require('fs');

// Read the JSON file
const jsonData = JSON.parse(fs.readFileSync('output.json'));

const dataArray = jsonData.users || jsonData;

// If dataArray is still not an array, wrap it
const finalData = Array.isArray(dataArray) ? dataArray : [dataArray];

// Log the data to verify it's not empty
console.log("Data being converted:", finalData.length, "records found");

// Create worksheet from the array
const worksheet = xlsx.utils.json_to_sheet(finalData);
const workbook = xlsx.utils.book_new();

xlsx.utils.book_append_sheet(workbook, worksheet, 'Sheet1');
xlsx.writeFile(workbook, 'output.xlsx');

console.log('JSON to Excel conversion complete!');

const xlsx = require('xlsx');

const fs = require('fs');

// Read the JSON file

const jsonData = JSON.parse(fs.readFileSync('output.json'));

const dataArray = jsonData.users || jsonData;

// If dataArray is still not an array, wrap it

const finalData = Array.isArray(dataArray) ? dataArray : [dataArray];

// Log the data to verify it's not empty

console.log("Data being converted:", finalData.length, "records found");

// Create worksheet from the array

const worksheet = xlsx.utils.json_to_sheet(finalData);

const workbook = xlsx.utils.book_new();

xlsx.utils.book_append_sheet(workbook, worksheet, 'Sheet1');

xlsx.writeFile(workbook, 'output.xlsx');

console.log('JSON to Excel conversion complete!');

Node.js Tutorial to Export JSON File to Microsoft Excel (XLSX) File Using xlsx Library in Terminal

Comments

Leave a Reply Cancel reply

Archives