Function findColumnIndexes

  • Finds all column indexes that match a name or pattern (case-insensitive).

    Parameters

    • worksheet: Worksheet

      The ExcelJS worksheet.

    • query: string | RegExp

      The column name or pattern to search for.

    Returns number[]

    An array of 1-based column indexes that match the query.

    const indexes = findColumnIndexes(worksheet, 'Name');
    const allDateColumns = findColumnIndexes(worksheet, /date/i);