Sometimes, we want to read an Excel file using Node.js.
In this article, we’ll look at how to read an Excel file using Node.js.
How to read an Excel file using Node.js?
To read an Excel file using Node.js, we can use the node-xlsx module.
To install it, we run
npm i node-xlsx
Then we can use it by writing
const xlsx = require('node-xlsx');
const obj1 = xlsx.parse(__dirname + '/myFile.xlsx');
const obj2 = xlsx.parse(fs.readFileSync(__dirname + '/myFile.xlsx'));
to call xlsx.parse with the path of the Excel file and assign the returned object to obj1.
Then we call xlsx.parse with a buffer returned from reading the Excel file with readFileSync and assign that to obj2.
Conclusion
To read an Excel file using Node.js, we can use the node-xlsx module.
