|
I'd like to define a hyperlink in a spreadsheet cell.
Using the text2table example, I tried
for (my $j = 0 ; $j < $columns && @cellvalues ; $j++)
{
#$doc->cellValue($cells[$j], shift @cellvalues);
$doc->setHyperlink($cells[$j], "CPAN", "http://www.cpan.org");
}
}
which I thought might fill every cell, but to no avail.
I also tried this:
for (my $j = 0 ; $j < $columns && @cellvalues ; $j++)
{
#$doc->cellValue($cells[$j], shift @cellvalues);
my @CellPara = $doc->getCellParagraphs($cells[$j]);
$doc->setHyperlink($CellPara[0], "CPAN", "http://www.cpan.org");
}
}
without success.
I also tried
$doc->setHyperlink($sheet, 'B2', "CPAN", "http://www.cpan.org");
but am still going nowhere fast. No sign of CPAN is showing up in the content.xml data file.
Any suggestions? Thanks.
|
