How to write string as hyperlink in excel

Help Studio
,
1

I am extracting below table from a webpage
image
I want to convert link column as clickable hyperlink.
Any solution for this?

Thanks in advance!

2

Hi, you can try to add a new column to your Excel DT and use Excel’s functions to achieve this.

Here’s an example: =HYPERLINK(“https://google.com”,“Google”)

4

@shameenapatel74

5

can you give example?

6

Cant use custom activities for this process. Any other way?

7

I tried this. getting output as below

image
image1356×339 71.6 KB

8

give a try by surrounding the url with " like:
grafik

keep in mind that we have to escape a " within a string with an additonal "

9

This didnt work. i am using for each row activity and in that activity I am using add data row to add each row and making this particular column as hyperlink

10

Why should it not work?

And here you can set formula and its value within the correct way

11

Can you share a sample xaml file for this?