Function getEmptyRows

  • getEmptyRows(worksheet): Promise<number[]>

  • Returns the indexes of empty rows.

    Parameters

    • worksheet: Worksheet

      The ExcelJS worksheet.

    Returns Promise<number[]>

    A promise that resolves to an array of 1-based row indexes that are empty.

    Example

    const emptyRows = await getEmptyRows(worksheet);
    console.log(`Found ${emptyRows.length} empty rows`);

Settings