See for example:
https://knowledge.safe.com/questions/78116/excel-featurereader-reading-empty-row.html
It would be great to have an option in the Excel Reader to ignore any rows that are completely empty i.e. have no values in them. This option could be left un-ticked if you really want to read in rows from a named range or where there is formatting but no data.
This would save having to spend time putting in a Tester or AttributeValidator to filter out the empty rows, or hard code ranges into the Reader when you need to be flexible.
Merged Ideas:
Add option to excel reader to only read 'non empty excel rows' by thijsknapen on February 20, 2021:
When reading in excel files, I noticed that sometimes empty rows are read in. It would be nice if there would be an option in the excel reader, to only read 'non empty excel rows' in the excel sheet.
This situation of 'empty excel rows' being read in, for instance occurs when an excel sheet contains cells that only contain formatting (but no value). However, also in the simple case where values are deleted in an excel sheet, the rows for that excel sheet will still be read.
I often encounter this situation when I use a structured/formatted excel file as an input for a translation. As sheets are re-used, and not always the same number of rows are entered, there are different number of empty excel rows that are read in in the translation.