cancel
Showing results for 
Search instead for 
Did you mean: 

How to get hyperlink in excel from odata ?

Former Member
0 Kudos

I have an Odata with entities like name , createdon , createdby , link etc . The functionality is , I show these data in a SAP UI5 Table and also have a download option . On click of the download button the whole table's data is downloaded as an excel . But in the excel , the link column contains the link as a text and not as a hyperlink .

* Passing <a href=" " ></a> dint work.

* Passing =HYPERLINK("https://.....","Click") also dint work . (In this case excel automatically appends a single quote before the =HYPERLINK formula ).

Accepted Solutions (0)

Answers (0)