const workbook = new Workbook();
await workbook.xlsx.load(input.file);

const resp = workbook.worksheets.map((worksheet) => {
  const headers: string[] = [];
  const jsonData: Record<string, string>[] = [];
  worksheet.eachRow((row, rowNumber) => {
    if (rowNumber === 1) {
      row.eachCell((cell, colNumber) => {
        headers[colNumber] = cell.text;
      });
    } else {
      const data: Record<string, string> = {};
      row.eachCell((cell, colNumber) => {
        data[headers[colNumber]] = cell.text;
      });
      jsonData.push(data);
    }
  });

  return {
    sheetName: worksheet.name,
    data: jsonData,
  };
});

console.log("Parsed data", resp[0].data[0]);