link an excell cell to a sheet

[kolahghermezz]

hey there,
I want to link some cells to specified sheets in an excel file.
Note : cell values and sheet names are the same and both cells and sheets are in same file.
is there any way ?

[ArjenEX]

Hi @kolahghermezz

Welcome to the KNIME Community!

Can you be a bit more clear about what your input and expected output is? Your question is a somewhat vague. Sharing a workflow, sample file, screenshots etc goes a long way since people are then more inclined to help you out

[kolahghermezz]

Dear Arjen Ex
Thanks for your attention and so sorry if my question wasn’t clear to you!
According your suggestion here is a Sample file to review !
1- On this file there are 4 sheets (value1 - value4)
2- On the first sheet there are same values on A1 - A4 cells
3- So I want to link each cells to corresponding sheet
BR

book1.xlsx (10.6 KB)

[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.