>Anyone know how to determine the number of the last row in an excel file that has data? Google searches didn't return any real solutions.

Not a DotNet expert, but if you can get UsedRange.Rows.Count, that should get it for you.