link an excell cell to a sheet

[ArjenEX]

It sounds like a job for openPyxl

Enabling hyperlink in Excel Through Knime

Hi, I was recently trying to incorporate a hyperlink in Excel. I used variable to table column and string manipulation to make the hyperlink since middle part of link is dynamic. I tried using evaluate formula of Excel Appender and Also Continental Nodes XLS formatter. Doesnt seem to work Please see the image for reference [knime%20issue] You need to manually press enter than only it changes to link. Any way to achieve this directly? since this will be connected to send mail node.

An alternative that you can try is try create a string =HYPERLINK(Value2!A1,"Value2") and put that in the output of sheet1.