Go through excel rows which has hyperlinks and open and print the pdf

[ohmytian]

Hi guys. Sorry i am new here and new to UiPath. So if anyone can help out that will be most awesome. So to explain what i am going to do here, i have an excel file with multiple rows of hyperlink. screenshot below. So i need to get UiPath to open the excel file, click on each hyperlink, go to the page, clt P to Save as PDF and repeat for the rest of the row in the excel. i have tried it out using the “For Each Excel Row” and it is ok for the first row. However, the actions were not repeated at the next row of the excel, and but the actions were repeated on the webpage that was opened instead.

Just to share abit further, For each excel row, i use the send hotkey (Shift F10) then send hotkey (Shift oo) then click on the "open hyperlink). However, after the firsrt PDF was saved, the Send hotkey (Shift F10) happened on the webpage rather than the next row of the excel. i have embedded the screenshots below. Appreciate if anyone can help me out here. Still pretty new to this. Thank you.

[ohmytian]

[ohmytian]

[postwick (Paul Ostwick)]

You don’t automate in Excel by using UI automation, clicking etc.

You do it with the Excel activities.

• Use Application/Browser to open your browser
  ** Use Excel File
  *** For Each Row in Excel
  **** Navigate To CurrentRow(“Name”).ToString

[Anil_G (Anil Gorthi)]

@ohmytian

Please check this on implmentation and some screenshots and steps

Extract specific data from a list of hyperlinks in Excel

one way is use excel process scope > use excel file add required columns if required or if already present ignore for each excel row Use Browser/ Application scope use go to url give input from currentitem(“FieldName”) do activities as you required and same time you can provide the values to respective fields by like “CurrentRow.ByField(“Des”).StringValue” use navigate Browser activity (select from dropdown option you required either close tab or goto home) [image] [image] [image] […

And if you are having trouble extracting url please check this

Read hyperlink from Excel without URL

just use a foreach loop here enumerable.Range(2,11) means start at row 2 and end at row 12 [image] then in the vba call , change the parameter to this [image] also, change the macro.txt to this to handle cells with NO hyperlinks (will output “No Link” if cell has no hyperlink) Function GetURL(cellAddress as string) As String On Error goto ErrorHandling: GetURL = Range(cellAddress).Hyperlinks(1).Address Exit Function ErrorHandling: GetURL = "No Link" End Function macro.txt (194 Bytes) te…

cheers

[ohmytian]

Thank you Paul! as im still pretty new let me go try to figure it out with your instructions. really appreciate your reply.

[ohmytian]

Thank you Anil! really appreciate your reply. your answer is a bit complex. but let me try to digest it first. thank you for helping

[Vikas_M]

Hey @ohmytian ,

Please refer below thread

Read hyperlink from Excel without URL

just use a foreach loop here enumerable.Range(2,11) means start at row 2 and end at row 12 [image] then in the vba call , change the parameter to this [image] also, change the macro.txt to this to handle cells with NO hyperlinks (will output “No Link” if cell has no hyperlink) Function GetURL(cellAddress as string) As String On Error goto ErrorHandling: GetURL = Range(cellAddress).Hyperlinks(1).Address Exit Function ErrorHandling: GetURL = "No Link" End Function macro.txt (194 Bytes) te…

Hope it helps you out!

[postwick (Paul Ostwick)]

I suggest the free training on the UiPath Academy web site. There is even one specific to Excel.