topic Re: Creating Excel sheet set with ole2_object in Application Development and Automation Discussions

Creating Excel sheet set with ole2_object

Former Member — Wed, 24 Sep 2008 10:26:31 GMT

Hi,

I am creating an excel sheet via ole2_object and I have this problem: I insert a bitmap in the sheet, and now I want to set an Hyperlink on this image, but I cannot find the method to call. Can anybody help me?

thanks

Gabriele

Re: Creating Excel sheet set with ole2_object

Former Member — Wed, 24 Sep 2008 14:48:58 GMT

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/204d1bb8-489d-2910-d0b5-cdddb3227820

Re: Creating Excel sheet set with ole2_object

Former Member — Wed, 24 Sep 2008 15:52:15 GMT

thanks it will be very helpful, but there are no reference to embed link;

I solved by myself "translating" perl call to hyperlink method I found googleing:

FORM here_we_go .

" ole2object for links in the sheet

DATA h_link TYPE ole2_object.

" set cell coordinates

CALL METHOD OF excel 'RANGE' = cell EXPORTING #1 = 'E20'.

SET PROPERTY OF cell 'VALUE' = 'google'.

CALL METHOD OF sheet 'HYPERLINKS' = h_link.

" sheet is the ole2_object representing the sheet

CALL METHOD OF h_link 'ADD'

EXPORTING

#1 = cell

#2 = 'http://www.google.com'.

FREE OBJECT cell.

FREE OBJECT h_links.

ENDFORM.

Hope this could help.

Gabriele