I can't extract data from Excel

Question

I am trying to extract data from an Excel file.

They are loading fine, but it tells me that worksheet.eachRow is not a function. How can I solve this problem??

const excel = require('exceljs');

function extractDataFromWorksheet(worksheet) {
 
    const data = [];

    try {
        worksheet.eachRow((row, rowNumber) => {
            if (rowNumber !== 1) {
                const numeroComercio = row.getCell('A').value; 
                data.push(numeroComercio);
            }
        });
    } catch (error) {
        console.error('Error al recorrer las filas:', error);
    }

    return data;
}

Answer 1

I testet and found it to work fine, but you are not showing how you extract the worksheet. Here's my test code:

const ExcelJs = require('exceljs');

function extractDataFromWorksheet(worksheet) {
  const data = [];

  try {
    worksheet.eachRow((row, rowNumber) => {
      if (rowNumber !== 1) {
        const numeroComercio = row.getCell('A').value;
        data.push(numeroComercio);
      }
    });
  } catch (error) {
    console.error('Error al recorrer las filas:', error);
  }

  return data;
}

async function openWorkbook(name) {
  const workbook = new ExcelJs.Workbook();
  await workbook.xlsx.readFile(name);
  return workbook;
}

async function test() {
  const workbook = await openWorkbook('xxxx.xlsx');
  // go through each sheet and process
  workbook.eachSheet((worksheet, sheetId) => {
    console.log(worksheet.name);
    if (worksheet.name === 'xxxx') {
      const data = extractDataFromWorksheet(worksheet);
      console.log(data);
    }
  });
  // or go directly to a sheet and process
  const data = extractDataFromWorksheet(workbook.worksheets[1]);
  console.log(data);
}

test();