Reading the excel and running multiple URL s in the browser and updating the excel if issue found for those URL s

Question

Task: How can I read and run multiple URL’s one by one from excel in the browser followed by writing/updating the excel if those URL’s has issues.

Answer 1

Try the following steps:

• use excel application scope and pass the file path as input

• inside the scope use read range activity and get the output with a variable of type datatable named dt

• now use a FOR EACH ROW activity and pass the above variable dt as input

• inside the loop use a OPEN BROWSER activity and mention the input as row(“yourcolumnname”).ToString

• So that it will open the url

Inside the mid open browser container we can keep the set of activities to be processed