Skip to Content

How to get hyperlink in excel from odata ?

Nov 24, 2016 at 02:38 AM


avatar image
Former Member

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers