const EXCELJS = require('exceljs');
const WORKBOOK = new EXCELJS.Workbook();
async function readExcel(filePath) {
await WORKBOOK.xlsx.readFile(filePath);
const SHEET = WORKBOOK.worksheets[0];
SHEET.eachRow((row, rowNumber) => {
console.log('row.values', row.values);
console.log('rowNumber', rowNumber);
});
}
readExcel('D:/test.xlsx');