1.How can we find in logs where exactly the error has occurred in our process
2.what if I have empty row or columns in my input excel file.how can I ignore them while running the bot
3.if I have 1000 rows and the error occurred in somewhere middle of it how can I identify

Use Try Catch .
Exception.message and Exception.Source Might help you Out.


Try Below to check empty cell in a row. It should be inside For Each Row activity.

IF String.IsNullOrEmpty(row(“ColumnName”).ToString)