Skip to Content
avatar image
Former Member

How to get hyperlink in excel from odata ?

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 ).

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

0 Answers