When reading your worksheet, we must determine which rows contain valid data. For example, your worksheet may contain 1000 rows but most of those rows may be empty. We must ignore those empty rows.

We detect empty rows by examining each row in the worksheet. If a row contains at least non-empty column value, we treat the row as a valid row. If every column value in the row is empty, we treat the row as an empty row and ignore it.

Columns containing Array formulas complicate empty row detection. A column with an array formula can have a non-empty field value even if the row is otherwise empty. That is the nature of array formulas. Consequently, we ignore any column having an array formula when deciding whether a row is empty.

You must ensure that at least one column in every row of your worksheet contains a non-empty value. Columns containing array formulas are ignored, so make sure the non-empty value is in some other column of the row.

Did this answer your question?