Uipath extract hyperlink from excel

Learn Video Tutorials
1

UiPath extract hyperlink from excel

ExtractHyperLink.zip (42.6 KB)

#uipath #uipathcommunity #excel #balareva

Regards
Balamurugan.S

1 Like
2

@balupad14
Thanks for your excel package. It is really helpful.
However, I used the extract hyperlink function to get around 27 hyperlinks from the excel.
When I extract them and put them into the DataTable.
I paste the DataTable on the excel to see the extracted result.
I found the sequence will be mixed. I do not know why the result will be mixed.
Can you help this?

3

Hello @balupad14 , It is very appreciated if you have some time to see this.
Do you also have the same issue to get mixed sequence when executing extact hyplerlinks function. Thanks

1 Like
4

Hi @David_Yu_yudavid ,

Can you please share some example workflow with example excel.

Thank you
balamurugan.s

5

@balupad14

image
image441×630 14.1 KB

The flow is pretty simple.

  1. Just extract the hyperlink from excel sheet. output is determined DataTable.
  2. Write Range by determined DataTable. You can see the result sequence is mixed.
    I do not know the reason. I expect to have the same sequence as original.
    Thank you for the help.

hyperlink excel
image

Write Range result

image
image990×248 8.76 KB

1 Like
6

Thank you for the feedback @David_Yu_yudavid .

I have done the changes. you can get the package here.

Regards
Balamurugan.S

1 Like
7

Thank you for your great help.
Your youtube and package are very helpful for UiPath RPA learner.
We can shorten the development time.
Thank you again.

1 Like