Hey,

You can use the VisibleRows property, but that goes all the way to the end of the sheet. I believe I just checked for the presense of values (where cell still has text). I haven't found a way using the API's where you can stop at the end of the data.

Another approach would be to load the excel sheet as a data source (using the DataAdapter) and access it that way.

Brian