Win32::OLE.pm and Hyperlinks
From: -b (docuswear_at_yahoo.com)
Date: 07/22/04
- Next message: Joachim Schrod: "Re: Help with Mail::Audit module"
- Previous message: Juha Laiho: "Re: DBI and DBI::Oracle packages configuration"
- Next in thread: Paul Lalli: "Re: Win32::OLE.pm and Hyperlinks"
- Reply: Paul Lalli: "Re: Win32::OLE.pm and Hyperlinks"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Date: 22 Jul 2004 12:09:16 -0700
I am using Perl and OLE.pm to read and modify an Excel spread***.
I can read the hyperlinked value of a cell using the following code:
my $cellObject = $work***->Range("A2");
my $hyperlink = $cellObject->Hyperlinks(1)->Address;
Can anyone explain how to modify the value of an Excel cell's
hyperlink, or to add one to a cell if it has no hyperlink?
-docuSwear
- Next message: Joachim Schrod: "Re: Help with Mail::Audit module"
- Previous message: Juha Laiho: "Re: DBI and DBI::Oracle packages configuration"
- Next in thread: Paul Lalli: "Re: Win32::OLE.pm and Hyperlinks"
- Reply: Paul Lalli: "Re: Win32::OLE.pm and Hyperlinks"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]