Hi,
If I understood correctly, RowCount does exactly what you say. It gives you the last row that has something. And again, this is very basic functionality, and you can be 100% sure it works. Basically, RowCount just gives you List<Rows>.Count.
If you are getting a RowCount of 8, then FlexCel read 8 rows, and there is nothing at row 10. There are 2 reasons I can think you might be getting this error:
-
You are reading the wrong sheet. Maybe you want to read sheet 2, but ActiveSheet is at row 1, which has 8 rows.
-
Some corrupt files could make FlexCel read only 8 rows even if Excel can read 10. This is very rare, and I haven't seen it in decades, but could be the case. If this is the problem, you can check it by opening and saving the file in Excel and then trying again.
If it isn't one of those, please send me the file that is giving you trouble (either post it here or send it to adrian@tmssoftware.com if it has any confidential data) and we will look at it.