Function: findColumnIndexes()

function findColumnIndexes(worksheet: Worksheet, query: string | RegExp): number[];

Defined in: src/excel/excel.tsx:680

Find column indexes that match a name or pattern. The search is case-insensitive.

Parameters

Parameter	Type	Description
worksheet	Worksheet	The ExcelJS worksheet.
query	string | RegExp	A column name or RegExp pattern.

Returns

number[]

An array of 1-based column indexes that match.

Example

const nameColumns = findColumnIndexes(worksheet, 'Name');
const dateColumns = findColumnIndexes(worksheet, /date/i);