Somebody please help here .How can i read data(cell values) from excel file in Puppeteer (Java script based tool). I have tried different npm packages like read-excel-file. Tried to write code like
xlsxFile("Book1.xlsx").then((data) => {
console.log(data);
});
AND
wb.xlsx.readFile("Book1.xlsx").then(function () {
//sheet object
var sheet = wb.getWorksheet("Sheet1");
//row object
let rowObject = sheet.getRow(1);
// cell object
let cellObject = rowObject.getCell(3);
var totalRowsIncludingEmptyRows = sheet.rowCount;
console.log(
"total number of rows are : " + totalRowsIncludingEmptyRows
);
for (let i = 1; i <= totalRowsIncludingEmptyRows; i++) {
let cellValue = sheet.getRow(i).getCell(2).toString();
console.log("Column B value from the row '" + i + "' : " + cellValue);
}
});
but nothing seems to work .i am trying to read data(cell values) from excel sheet .Please help. Thanks