Business
Jobs
  • About Us
  • Solutions
    • Job Postings
      Post your job and receive qualified candidates in 48h.
    • Candidate Assessments
      500+ technical and psychological tests, plus anti-fraud.
    • Headhunting
      Tailor-made executive search from start to finish.
    • Payroll + EOR
      Payroll dispersal and EOR across 15+ LATAM countries.
  • Pricing
  • Jobs

0

380
Views
How to read data from excel file in Puppeteer (Java script based tool)

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

about 4 years ago · Juan Pablo Isaza
Answer question
Find remote jobs

Discover the new way to find a job!

Top jobs
Top job categories
Business
Post vacancy Pricing Sales
Legal
Terms and conditions Privacy policy
© 2026 PeakU Inc. All Rights Reserved.
Andres GPT
Show me some job opportunities
There's an error!