how to detect end of file of my excel page

Hi,
I have windows application that use com interop. This app successfully read and write to the excel page. My problem if have 10 or more lines how to detect the End of File?


thanks

Why not drop a unique value into the first column at the end of your data. Then just search for that? Its quick and ugly but its easy to implement.

I think this approach is not applicable in this method. The data in excel came from copy n paste manually. So if apply this, everytime the user put data to excel he/she needs to manually append to the last item but thanks for the idea. Hope anyone can help me out of this or what is the best approach?



thanks,