Matterway
    Preparing search index...

    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);