Skip to Content
0
Former Member
Feb 27, 2009 at 11:01 AM

Displaying hyperlinks in excel?

730 Views

Hi all,

I am creating an application using BSP wherein i have to export the data to the Excel sheet through the BSP application. I am able to export the data from tables to the excel but there are some hyperlink entries in the database tables which i need to fetch and display in the excel. The problem is excel is not displaying those web addresses like "www.sap.com" as hyperlink.I tried to concatenate it with ' http:// ' , but its not converting the values into hyperlinks. Can anybody please suggest how to display the hyperlink values from database table into the excel sheet?

Thanks in Advance,

Mahima.