~~David~~ has asked for the wisdom of the Perl Monks concerning the following question:

All, I am currently using Spreadsheet::WriteExcel to write a cell like so: 

$worksheet -> write_url($row, $col, $url, $name});

[download]

I now want to use Spreadsheet::ParseExcel to pull out both the Value of the cell ( currently stored in $name ) and the hyperlink.
I have used Data::Dumper to dump every single Cell property, and I can't seem to find the hyperlink.
Is this possible? I tried searching this site to no avail.

Replies are listed 'Best First'.
Re: Using Spreadsheet::ParseExcel To Read Hyperlinks
by regexes (Hermit) on Oct 23, 2008 at 07:04 UTC
    Hello,

    According to the man page in the TO-DOs section..

    - Spreadsheet::ParseExcel : Password protected data, Formulas support, HyperLink support, Named Range support

    Doesn't look like it's supported yet...

    regexes



    -------------------------
    Nothing in the world can take the place of persistence. Talent will not; nothing is more common than unsuccessful men with talent. Genius will not; unrewarded genius is almost a proverb. Education will not; the world is full of educated derelicts. Persistence and determination are omnipotent. The slogan "press on" has solved and always will solve the problems of the human race.
    -- Calvin Coolidge, 30th President of the USA.
[reply]

Back to Seekers of Perl Wisdom