I have an issue. I have an excel file which contains input data for a website. I have 7 columns and multiple rows. Each row must be entered to the website as a form. Here is what I did up to now:
- In an excel application scope, I used read range activity and created an output datatable.
- Next activity is for each row. In the body section I am using try-catch activity, in the try block I have all the actions (creating variables for excel column values, clicking and typing into the website areas, submitting the form etc.)
- In the catch block I have system.exception statement in case of any errors.
What I want is, if any error occurs during any row (saving is not done), it should move to the next row. But also I need to know which row the error occured. Because after the automation, I will enter them to website manuelly. I thought that, in the excel file maybe in a new column I can write their status like OK/NOK for each row. But I don’t know how to do that. Should I include this steps in the catch block? Writing only NOK records on a notepad works just as fine, I just need to know which ones haven’t been created in the website.