Skip row or stop reading after reaching empty cell (not a blank row) or incorrect type about excelmapper

[apoorvmintri]

Alright. Used custom mapping to avoid errors, followed by .Where() to filter.

Was hopping there was a way to handle rows with incorrect types to avoid performance drop (over 100000 rows). But this is still the quickest library with a readable code compared to other libraries. Awesome work! Thanks!

[mganss]

If the mapping doesn't generate any errors I would probably handle this with a classic .Where() (or .TakeWhile()). Otherwise you can try and use the custom mapping methods to avoid any errors and then filter.

If you do know the range of rows in advance you can use the data row range properties.