Excel, OLE, Hyperlinks

Ad Aspera has asked for the wisdom of the Perl Monks concerning the following question:

To: Seers of Perl
I am new to OLE Automation for Excel with Perl.
I have a cell A1 containing text "123" and an associated hyperlink such as( http://www.somewhere.com/get.php?id=123)
I want to go to A1, get the text for the hyperlink at A1, and place to contents of the text in E1.
I tried:

$cellA1 = $worksheet->Range("A1")->{'Value'};
$worksheet->Range("E1")->{'Value'} = $cellA1;
[download]

instead of getting the text of the hyperlink, I get the entire contents of A1 in E1.
How can I get just the text of the hyperlink in E1?

Comment on Excel, OLE, Hyperlinks Download Code

Replies are listed 'Best First'.
Re: Excel, OLE, Hyperlinks by gellyfish (Monsignor) on Mar 23, 2005 at 16:47 UTC
See the description of the Hyperlink object from the MS documentation. /J\	[reply]