Web automation and Excel start choice

Help
1

Hello everyone,
I am automating a web app.
The robot is reading lines from Excel.
The Excel contains the columns “Name”, “Age”, “Status”
After treating the process, the column status will take the value of “OK”.
Now if the processus is broken due to electricity problem, I want the robot to start from the cell that contains an empty status, not starting from the beginning.

How to do?

Thanks

2

@Youssef

I hope you are reading data from excel and filling in web application and then updating status in “Status” column as ‘Ok’.

Before reading check whether column status value is empty or not.

If String.IsNullOrEmpty(row(“StatusColumn”).ToString.Trim)
Then continue your steps
Else Skip record

Are you using REFramework or not for this process ?

3

Thanks a lot!
Yes!
By skipping you mean "End process activity ?
Thanks

1 Like
4

@Youssef

No. You have to throw exception using Throw activity. And make sure this flow should be in Try catch block. Then when status column is not empty it will throw exception and corresponding Catch block will catch it and will go to the next record.