The syntax is correct? If i would insert a data item that contains url?You can make use of Excel formula "=hyperlink()" while writing the string in to Excel spreadsheet make string appear as hyperlink.
Example: If you want to write path/url in to cell A1, here are the inputs you can for "Set Cell Value" action -
handle: <handle>
cellref - "A1"
value - "=Hyperlink(" & """https://rpaforum.net"""& ")"
This writes string in to A1 and the string appears as hyperlink. You can pass the file path as well in place of url above.
Hope this helps!
I have this collection that is written in excel. Every value of coumn "Path" I have to make it hyperlinkI did not quite get it. Elaborate...
what do you mean?You may alter the column in collection to have the hyperlink formula.
i mean, using a Calc stage to change the value of the Collection.what do you mean?
My calc is: "=Hyperlink("&"""" & [Destination Path]&""""& ")"
Is ok, missed two "