Trying to write a hyperlink formula into an excel file

Help Studio
1

Hello,

I have a problem with writing an Excel formula into an Excel file.

my workflow has a data table that will be written to an Excel file later.
Within the data table I try to add a hyperlink formula for each row (screenshot 1).

1
11172×285 11.3 KB

When I open the finished Excel file, the formula is written in plain text.
It is only converted into a hyperlink when I click on the cell and press Enter (screenshot 2)

2

2

Hey @devinsta :wave:

Try this:

{"=HYPERLINK("C:\Users\Test\Documents\UiPath\","Hier")"}

Let me know if you are facing any issues.

Cheers!

3

hey @monsieurrahul

thanks for ur help but unfortunately it doesn’t work.

4

@devinsta
have a look on the balareva.easyexcel component and the offered activites related to hyperlinks:
grafik

2 Likes
5

thank you @ppr

i had to redesign the workflow a bit, but it is working.

1 Like
6

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