Props for not asking for the direct answer - makes me far more willing to help you @ovi take note I am sometimes nice!!
Let’s talk through the logic to get you started…
Read the Excel file into a datatable - one of your columns will be called “URL”
Loop through the datatable using the For Each Row activity and assign the URL for each particular row by doing this :
myCurrentURL = row(“URL”).ToString
Take the myCurrentURL value and enter it into the web browser (and do the other things you would like to do)
Collect the additional information by using get text activities (or screen scraping if needed) - use IE if you can.
Still within the for each take the extracted information and set it to the row e.g. if you had extracted domain name:
row(“Domain Name”) = myDomainName - where myDomainName is the value extracted from the web page.
Note, at some point you will need to add new data columns or create a brand new data table.
Hope this gets you started - shout if you get stuck. Also there are plenty of useful articles on the forum.
But the request is also pertinent so gg @forest81. Please note that you can also register for free on the UiPath Academy, you’ll find a lot of useful courses.
Hi Richard and sorry for delay, it’s been a busy week (once again). Thanks for tips! Once I’ll have time, I will try to get further with my problem, that’s for sure. I will let you know if I face challenges again.
@ovi, good to know that academy is free! I will have tour there, too.
how do I define the scope of the Excel? I mean I wouldn’t like to define the range in Read Range because if this robot becomes re-usable, the amount of domains/urls in Excel varies each time. My concern is that all I want to put into DataTable are the domains, not the header “URL” which stands in B1 and nor the header in C1 and D1 which are the headers for result columns.
I am able to read the contents of Excel, but how do I tell the For each row component to pick one domain at the time? Output data table input is DT1 and output is variable myCurrentURL.
Here is an example: test.xaml (17.5 KB)
It was a similar request in another post(i can’t find it now) to go to a website, scrape all the results(including URL). Then, go to each URL and extract a date and put it in another column of the datatable.
Please check it out.