Re: Win32 Perl and writing to Excel Workbooks

If switching to Spreadsheet::WriteExcel is an option then you should be able to use the write_url method to insert a hyperlink. From the doc:

$worksheet->write_url('A3', 'http://www.perl.com/', $format);
[download]

-- vek --

Comment on Re: Win32 Perl and writing to Excel Workbooks Select or Download Code

Replies are listed 'Best First'.
Re: Re: Win32 Perl and writing to Excel Workbooks by talwyn (Monk) on Dec 28, 2002 at 00:32 UTC
I looked at that... And I don't think it will suit my application as I am writing the results of an SQL query from a database and it was easier to write the results out with SQL as well rather than calcing the cells. I was wondering if there was a hidden character used to indicate a link and if so what it was. Or else how the link is formatted -talwyn	[reply]