To read Excel file using Node.js, we call the ExcelJS readFile
method.
We install it by running
npm i exceljs
And we write
const ExcelJS = require("exceljs/dist/es5");
const workbook = new Excel.Workbook();
await workbook.xlsx.readFile(filename);
to create a workbook
with the Workbook
constructor.
Then we call readFile
to read the filename
file into the workbook
.