Reading url's from excel and navigate with the extracted url

Help
, , ,
1

Hello everyone,

I am trying to read an excel which has url’s data, after reading i need to navigate through each url and perform some actions.
Please suggest me the best possible way.

Regards.

2

Use Read Range for Reading excel data
Then using for Each row u can iterate those URL’s
In that then u can use navigate to
in address type Row(“ColumnnameInwhich your url present”).tostring
and then perform your actions

3

Are these URL in 1 cell, comma separated or each row has 1 URL? can share the sample excel?

4

Hi
Welcome back to uipath community
Hope these steps would help you resolve this
—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

Cheers @varma

2 Likes
5

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.