topic Create Hyperlink in Excel in Application Development and Automation Discussions

Create Hyperlink in Excel

Former Member — Wed, 28 Oct 2009 11:15:58 GMT

Hi,

I have an excel file with different filenames in each cell.

I am trying to hyperlink each cell with the corresponding file path..

I had searched one thread in SDN but my problem is not solved .

Can anyone help me on this with a sample code.

Thanks

Sekhar

athavanraja — Wed, 28 Oct 2009 11:40:22 GMT

when you populate the cell content pass it like below


=HYPERLINK("D:\Users\xxx\Desktop\myfile.txt","test link")

Former Member — Wed, 28 Oct 2009 11:43:10 GMT

Thanks Raja,

I am not populating cell by cell data but i am using cl_gui_frontend_services=>clipboard_export to paste the data to excel file..

Former Member — Fri, 30 Oct 2009 08:33:13 GMT

Hi,

To create hyperlink i had used this

SET PROPERTY OF cells 'Value' =

HYPERLINK("D:\Users\xxx\Desktop\myfile.txt","test link").

but displays a syntax error , does anyone have any idea

Thanks

Sekhar

Former Member — Fri, 30 Oct 2009 10:17:30 GMT

Hi,

try this:

SET PROPERTY OF cells 'Value' =

'=HYPERLINK("D:\Users\xxx\Desktop\myfile.txt","test link")'.

regards, Dieter