Read url from excel

Hi how can i read website url from excel…

image

Thanks,
Suresh.

1 Like

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

Hi @suresh_kumar4,

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

Regards
Balamurugan.S

Hi @suresh_kumar4,

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

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

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