how to get last row where data is present in excel


I’m trying to get the last row where data is present in the excel so that i can add new values to that excel file. but when i tries above method i’m getting last row as 15 which is wrong.

can any one please help.

hi, I am facing similar issue, are you able to solve now?


As you can see in the log file, there are data " " in the consecutive rows and columns and hence Bot is considering that as a valid record. Please delete the entire rows starting from row 2 similarly delete the entire columns from D till z and try running it