Home > Archive > PERL Beginners > March 2005 > Excel, OLE, hyperlinks
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Excel, OLE, hyperlinks
|
|
| Lee Marlin 2005-03-24, 8:56 am |
| 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;
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?
________________________________________
__________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
|
|
|
|
|