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
Back then there was no Continental nodes for Excel available so maybe you can make it work now without CSV Writer node. Give it a try and let us know how it went
Hi @mlauber71
Thanks for reply. This I tried and it works. Sorry for too many questions
But I tried for eg- ws[‘A2’:‘A5’] , ws[‘A2:A5’] , none seems to work . Basically i want to pass range of cells dynamically.
I think in general this ‘style’ should work: 'B2:F4'
Maybe it is best you toy around with what you want to do and read some blog entries. OpenPyXL offers a lot of possibilities but can also be complicated.
I think some planning and experimenting is necessary. This blog offers some insights into formatting: