Iterate through rows which has hyperlinks and open and save the pdf available in it! is it possible? how to?

Help StudioX
, , ,
1

Hy all
I am new to UIpath.
I have data in excel which contains the name of the building and their Electricity&water bill URL.
I want to download each building pdf and print it.
can anyone help me, please?
image

2

HI sure its possible you can use For each activity and create workflow to download and print it

1 Like
3

Hi @Imran_Mohammed,

Welcome to the community.

Use a excel application scope enter the file path with name in it-> use read range to read the sheet and output it in a DT say Dt1->- use a for each row loop pass Dt1 in it → inside for each use an Open browser activity in that pass Rowvariable(“LINK”).tostring this will open the web page-> now downloading pdf part if there is some button or interaction to download the file proceed with it-> post that use a close tab activity to close tab. Remember when using Open browser check on the property setting “New session”.

Thanks

1 Like
4

Hi @Imran_Mohammed

Welcome to community!

We can also go with below method without using browser intertaction!

Regards

2 Likes
5

thank you it worked and there is interaction so I used click activity with check app status activity.

6

thanks

7

I made it to print now, I have a column for dates like bills come on every month of 5 15, and 28.
so I have a column for that which building have bills on 5 and which is on 15 so on.
can the bot check the system date and filter that column and then execute the rest?..
I tried filtering by data table activity but it doesn’t work. can you help me out? thanks

8

Sure!!

As this issue was resolved can you please open a new thread on the forum with your latest challenge so that it can grab everyone’s attention and you can get maximum beneficial answers.

Thanks

1 Like
9

sure

10

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.