Read url from excel

Help
, ,
1

Hi how can i read website url from excel…

image

Thanks,
Suresh.

1 Like
2

Hi @suresh_kumar4

Hi use read range and give the range as “B1”
and use for each row in dt

print the row value based on index as 0

Thanks
Ashwin S

3

Hi @suresh_kumar4,

Here is an activity called Extract hyperlinks.Using this activity you can able get all the hyperlinks.

image
image454×553 42.2 KB

Regards
Balamurugan.S

4

Hi @suresh_kumar4,

Use Read excel workbook Activity -->For Each Row Activity & in the Body use Write Line Activity → row(1).ToString

5

Hi @suresh_kumar4

– use excel application scope to read the path
–And use read range to read and set datatable
–And use assign activity and create a variable in to and in value pass the datatable which u use in read range and write dt.column(1).tostring so you will get the email

image

If you find it useful mark it as solution and close the thread.

image

Regards,
gulshiyaa

1 Like
6

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