Sometimes, we want to parse XLSX and create JSON with Node.js.
In this article, we’ll look at how to parse XLSX and create JSON with Node.js.
How to parse XLSX and create JSON with Node.js?
To parse XLSX and create JSON with Node.js, we can use the xlsx package.
To install it, we run
npm i xlsx
Then we use it by writing
const XLSX = require("xlsx");
const workbook = XLSX.readFile("Master.xlsx");
const { SheetNames: sheetNames } = workbook;
console.log(XLSX.utils.sheet_to_json(workbook.Sheets[sheetNames[0]]));
to call XLSX.readFile to read the XLSX file from the path in the argument/
Then we get the sheetNames from the workbook object.
Next, we call XLSX.utils.sheet_to_json with the first sheet which we get from workbook.Sheets[sheetNames[0]] return the JSON data converted from the worksheet.
Conclusion
To parse XLSX and create JSON with Node.js, we can use the xlsx package.
