I have an excel file with some url’s and I want to navigate through each one so I can extract some data. I have a read range but I don’t know how to set the url to my variable url.
Please try this steps,
- read the excel sheet in a datatable( variable name dt_table)
- use an open browser activity and open any specific browser.
- use for each row and pass the datatable.
4.Inside for each use navigate to activity and navigate to the url.
5.extract the data.
Main.xaml (11.6 KB)
Ok, I have a excel application scope, a read range, a for each row in data table, and a message box (for testing purposes).
But I don’t really know how to do what you suggested (I am new to UiPath)
Inside for each row,
- Use open browser activity instead of message box and pass currentrow(0).tostring,
hope the url is in first column of excel file. (it will open a browser with the url in the excel)
Use get text activity and extract the data in the webpage.
Use close application activity and close the browser opened already.
Thank you very much. That’s solve my problem, I really appreciate your help.
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.