Read values from excel and open a browser

Help
1

Im started learning RPA to automate my daily work.appreciate ur help here!
I need to read list of values from an Excel and open a browser by appending the value from excel to do some operations… How can I do that??

2

Hi @vadhav,
Use read range to read values from Excel sheet.
And next if you want to open the browser with url coming from excel , then use for each loop and take open browser activity ,call the row(column name or index) in the url section.
Let me know if you need more information!

Best Regards,
Santosh Pothina

3

Excel doesn’t have URL. Ex:

ColA
123
456
789

URL should be like…
Google.com/123 … Do some activity and open google.com/456 and goes on…

4

You requirement was not clear enough initially… I tried though :smiley:
Now,just concatenate row value with the URL specified.
Ex: “www.google.com/"+row("ColA”).tostring , put this in url parameter.

Regards,
SP

5

Thanks… LL try and keep Yu posted!

6

Im started learning RPA to automate my work.appreciate ur help here

I have a scenario where i need to open the Excel and open a browser by appending the value from excel to do some operations.
i.e open the excel and getting the url and opening the url and passing the username and password to open the url ,once it done i need to logoff and go to excel again and pick the 2nd url and login the url again ,like this i need to iterrate the loop for checking all the urls listed in the excel.

could you please help

thanks

7

did you get solution for that, can you please with me thanks