Adding a row to a data table problem

[goropopovic (Goran Popovic)]

Hi everyone

I am trying to add a row to a datatable

And this datatable has only one column

The text that is suppose to be added as a row in a table is:
=HYPERLINK(“C:\Users\gorop\Documents\UiPath\Condion i Screenshot clear all sa Check all\Chart Screenshots\XXX.png”, “Open Image”)

(That table is latter going to be inserted into Excel and serve as a formula in certain excel cells.)

To add this text as a row to a datatabale I am using an “Add row to datatable” activity and “add list as row” field.

This is what I type into the expression editor under the “add list as row”:
{ "=HYPERLINK(“C:\Users\gorop\Documents\UiPath\Condion i Screenshot clear all sa Check all\Chart Screenshots\xxx.png”, “Open Image”) "}

It reports an error. I suppose its because of all of these quotes

What do you think I should do?

[SorenB]

Hello @goropopovic

You could try to use this code for quote:

Chr(34)

So for example:

Chr(34)+"=HYPERLINK(....

Regards
Soren

[goropopovic (Goran Popovic)]

@SorenB

Chr(34)+"

You mean like:

{Chr(34)+"=HYPERLINK(“C:\Users\gorop\Documents\UiPath\Condion i Screenshot clear all sa Check all\Chart Screenshots\xxx.png”, “Open Image”) "}

No, that does not work

[ijanszen1 (Ijanszen)]

@SorenB that’s a cool idea, haven’t seen that yet.
@goropopovic when you hover over the red dot with your mouse, what does the error say?
No need to ‘suppose’, UiPath should give some information there

[goropopovic (Goran Popovic)]

Hi ijanszen

it says

[Ones (Ones Romero)]

Hi @goropopovic
the charter " scapes the string. So, if you want to have a " in the middle of the string try to write it with double ", like this:

              ||
              vv
{ "=HYPERLINK(""C:\Users\g...

Best Regards

[goropopovic (Goran Popovic)]

Yes! Now Its good!
Thank you!

[SorenB]

Hello @goropopovic

Good that you have found a usable solution.

Just to clarify, I didnt mean to just replace the initial quote with Chr(34).
I meant that you can use the Chr(34) in stead of quotes.

Try it out until Studio accepts the format and you get the desired output.

Regards
Soren