You’re offline. This is a read only version of the page.
14
The company I am currently working at is trying to adopt RPA system. What we are trying to do is to get excel file from a certain website.
Link : https://emergingtextiles.com/
On the website, we need to click on the link such as
and there are about 30 different links that I need to extract the data from.
There are links on the website not only with the title that ends with (Weekly Report), but there are also titles that end with (Monthly Report) and etc, but I only have to download the files in which their titles end with (Weekly Report).
To summarize, the step by step is like this:
1. Open the web and enter the link
2. Log in (I did upto here)
3. Search for the link in which its title ends with Weekly Report and click it.
4. Scroll Down.
5. Click on "Download CSV file"
6. Go back to the main page and repeat from step 3.
As I said before, there are more than 20 different links that I need to enter and download the excel file.
What would be the best way to handle this problem?
Thanks in advance!
Hi @yscx523194
For step 3, you can follow the solution from @Highboy in this direct link here.
Only difference you can make is, instead of the Excel (shown in the post) you can also read the links by directly looping through the datatable.
No need to scroll if you achieve step 5.
For step 5 - This will depend on how your download csv link or button is.
Capture the UI element for that link/button and then try PAD actions like "click link on web page" or "click download link on web page"
For step 6. Use the "go to webpage" action.
Share
Report
All responses (
Answers (
