For each loop with URL + downloading excel

RPA Discussions
,
1

how to open several URL’s, download excel to the right path ?

2

Hi @Nightowl_music
Take a look at this video . Hope it might help you

3

hey

you can use the navigate to activity to navigate to the page to download the excel, then just right click in the excel file and click on save as, so chrome open the window and you can specify which path you will use

regards

4

hello im going to multiple URL’s with different excel files. who has to be stored on different places

5

you can download the file and use the move file activity, or use a switch activity

regards

6

if I use it in a for each. how to order my URL’s ? because every URL has to be stored with a specific name.

7

can you provide an example please? so i can understand better your query

regards

8

@Nightowl_music

If you have all the URL listed in Excel then you can use ReadRange activity to read the Excel file, use For Each row activity to loop into the excel

Inside For Each row activity you can place your automation like opening browser, Navigating to the pages, clicks etc required to download excel

Hope this may help you

Thanks

9

ok thanks. only every URL. needs a rename and different location. for example if it’s start with ROW1… how do I specific the right action in the loop

10

@Nightowl_music

So, If your requirement is not a static one to the all URL’s, let say flipkart.com then define your separate workflow for flipkart, next url is say amazon define separate workflow for Amazon

You can always check if there are some fixed steps applied to those then those can be done in one workflow and reuse that workflow

Now in Main workflow, you check If the url is Flipkart then Invoke the flipkart workflow, If it is amazon then invoke amazon workflow

Hope this may help you

Thanks