import * as xlsx from 'xlsx';

export class ExcelUtil {
  static readExcel(fileBuffer: Buffer): Record<string, any[]> {
    const workbook = xlsx.read(fileBuffer, { type: 'buffer' });
    const data: Record<string, any[]> = {};

    workbook.SheetNames.forEach((sheetName) => {
      const sheet = workbook.Sheets[sheetName];
      data[sheetName] = xlsx.utils.sheet_to_json(sheet);
    });

    return data;
  }
}