Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Creating Excel sheet set with ole2_object

Former Member

‎09-24-2008 11:26 AM

0 Kudos

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

2 REPLIES 2

Former Member
In response to Former Member

‎09-24-2008 4:52 PM

0 Kudos

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