WriteExcel internal hyperlink

[Sean]

I got a question about creating hyperlinks to internal worksheet
references using Spreadsheet::WriteExcel;.

$worksheet->write_url('A6', 'internal:Sheet2!A1'); # works with
constant.

My question is whether or not the cell reference is variable
interpolated as follows:
$whichcell = A1;
$worksheet->write_url('A6', 'internal:Sheet2!$whichcell');

I tried but it cound not create the hyperlink. Anybody know if there
is a way to assign cell to the hyperlink at the run time using a
variable instead of a constant string?

thanks

Sean

 

[Paul Lalli]

I got a question about creating hyperlinks to internal worksheet
references using Spreadsheet::WriteExcel;.

$worksheet->write_url('A6', 'internal:Sheet2!A1'); # works with
constant.

My question is whether or not the cell reference is variable
interpolated as follows:
$whichcell = A1;
$worksheet->write_url('A6', 'internal:Sheet2!$whichcell');

I tried but it cound not create the hyperlink. Anybody know if there
is a way to assign cell to the hyperlink at the run time using a
variable instead of a constant string?

I know nothing about this module, but by any chance did you try to
actually interpolate the variable? As in, use a double quoted string
rather than single quotes? That's a Perl standard. . . .


Paul Lalli