does the package support hyperlinks created using variables?
For example I have a column where I create a string using the Excel HYPERLINK formula, something like =HYPERLINK("{{url}}","{{display_text}}") but this does not act as a hyperlink (i.e. does not open the link) when I open the rendered Excel workbook. If I edit the workbook and press Enter on each cell then it converts to a proper hyperlink.
I have a workaround where I use OpenPyXL to convert each of these cells to a hyperlink after rendering the workbook, but it would be nice if I could do this directly in xltpl.
zhangyu836
commented
1 year ago
Hi,
does the package support hyperlinks created using variables?
For example I have a column where I create a string using the Excel HYPERLINK formula, something like =HYPERLINK("{{url}}","{{display_text}}") but this does not act as a hyperlink (i.e. does not open the link) when I open the rendered Excel workbook. If I edit the workbook and press Enter on each cell then it converts to a proper hyperlink.
I have a workaround where I use OpenPyXL to convert each of these cells to a hyperlink after rendering the workbook, but it would be nice if I could do this directly in xltpl.
thanks.