Export hyperlinks to copy,csv, or excel
Export hyperlinks to copy,csv, or excel
BPAT
Posts: 28Questions: 13Answers: 1
Let's say I have text in a column that contain regular text and hyperlinks in it. Is it possible to export it via any of the buttons so that it would appear? Current when I export it the code for the hyperlink does not appear (<a href="">LINK</a>), just the text in the link appears. Sorry if this has been asked before. I have searched and also read the reference material but can't find the answer. I guess I'm not smart enough.
This question has an accepted answers - jump to answer
This discussion has been closed.
Answers
can we get an update on this issue?
This link: https://ankushbhatia.wordpress.com/2011/03/04/how-to-insert-a-hyperlink-in-excel-using-open-xml-sdk-2-0/ describes how to add hyperlinks to the XML documents in order to create a spreadsheet with hyperlinks.
Basically, you'll have to create a relationship in a new relationships file for sheet1.xml. This relationship will specify the "target" for your link.
The DataTables excelHTml5 buttons is designed to handle whatever xlsx structure your customize function returns. You can add new XML documents to xlsx and they should be properly zipped.
@ttse23 Please post your specific solution once you have it working