in reply to Re^2: Testing for Excel hyperlinks with Win32::OLE
in thread Testing for Excel hyperlinks with Win32::OLE
And then while you're looping over the cells to write out the HTML:my $cellsWithHyperlinks = {}; $cellsWithHyperlinks->{ $_->Column }->{ $_->Row }++ for map { $Sheet->Hyperlinks($_)->Range } 1 .. $Sheet->Hyperlinks->C +ount();
foreach my $col ( 1 .. 10 ){ warn "Col # $col has hyperlinks somewhere" if exists $cellsWithHyper +links->{$col}; foreach my $row ( 1 .. 10 ){ warn "(Col,Row)=($col,$row) has a hyperlink" if exists $cellsWithH +yperlinks->{$col}->{$row}; } }
|
|---|
| Replies are listed 'Best First'. | |
|---|---|
|
Re^4: Testing for Excel hyperlinks with Win32::OLE
by sz (Friar) on Sep 27, 2005 at 19:53 UTC |