import * as XLSX from 'xlsx';

export function findColumnByLabel(sheet: XLSX.WorkSheet, label: string): string | null {
    const range = XLSX.utils.decode_range(sheet['!ref'] || '');
    for (let col = range.s.c; col <= range.e.c; col++) {
      const cellAddress = XLSX.utils.encode_cell({ r: 0, c: col });
      const cell = sheet[cellAddress];
      if (cell && cell.v === label) {
        return XLSX.utils.encode_col(col);
      }
    }
    return null;
  }

  export function findRowByLabel(sheet: XLSX.WorkSheet, label: string): string | null {
    const range = XLSX.utils.decode_range(sheet['!ref'] || '');
    for (let row = range.s.r; row <= range.e.r; row++) {
      const cellAddress = XLSX.utils.encode_cell({ r: row, c: 0 });
      const cell = sheet[cellAddress];
      if (cell && cell.v === label) {
        return XLSX.utils.encode_row(row);
      }
    }
    return null;
  }