jsreport / jsreport-xlsx

jsreport recipe rendering excels directly from open xml
https://jsreport.net/learn/xlsx
MIT License
8 stars 8 forks source link

Hyperlinks #25

Open zoell opened 7 years ago

zoell commented 7 years ago

Is it possible to insert hyperlink in a cell?

pofider commented 7 years ago

Everything that is supported by excel should work with recipe as well. That is the beauty.

Try to add a hyperlink in the excel app. Save it. Rename the output xlsx file to the zip file. Decompress it and see what is the proper format for hyperlink. Then use xlsx helpers to replicate the same through the jsreport.

If you want to later share your investigation with others, put here a playground link. We would add it to the list of xlsx examples we have https://jsreport.net/learn/xlsx#examples. It would be appreciated, thank you.

zoell commented 7 years ago

I already checked that. The xml workbook file in the xlsx imports the hyperlink as a resource from other files as I noticed.