jmcnamara/excel-writer-xlsx

write hyperlinks embeded in texts

spz1st opened this issue · 2 comments

I would like to be able to create a cell with clickable hyperlinks embedded in texts, but seems the current implementation only allows to create a cell with a standalone clickable hyperlink, nothing else can be included in the cell. Otherwise the text with the hyperlink will be shown as plain text. I've read the documents and searched the web, but couldn't find a way to achieve it. I've posted at stackoverflow (https://stackoverflow.com/questions/70524064/excelwriterxslx-write-embedded-hyperlinks), but no one responded.

Sorry, I missed that on Stack Overflow.

Unfortunately that isn’t possible in Excel (and hence not in Excel::Writer::XLSX). It is only possible to have one hyperlink per cell.

Thanks. I'm closing the issue now. You may delete it if you like.