I have created a process in which we are taking excel as an input. Even if the data is not available in the row, process is executing those rows.
For example, if I have data till 3rd row but still bot is executing the 4th row.
As a solution, I tried to add condition that if value for 1st column is not blank then execute the record. But when it reach to 4th line, it is giving error as “object reference not set to an instance of an object”. Instead of giving this error, bot should stop the execution as there are no records available for execution.
Please suggest the solution for this.