B
-b
I am using Perl and OLE.pm to read and modify an Excel spreadsheet.
I can read the hyperlinked value of a cell using the following code:
my $cellObject = $worksheet->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
I can read the hyperlinked value of a cell using the following code:
my $cellObject = $worksheet->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