Re: Spreadsheet-ParseExcel Problem Reading URL in Cell

dperriero,
You are using the Value() method which, per TFM, gives you the formatted value of the cell. Since you have text formatted as a number - I am not terribly suprised you are getting 0. You may want to use the Val() method instead which gives the original value.

Cheers - L~R

Comment on Re: Spreadsheet-ParseExcel Problem Reading URL in Cell

Replies are listed 'Best First'.
Re^2: Spreadsheet-ParseExcel Problem Reading URL in Cell by dperriero (Novice) on Jan 18, 2006 at 21:39 UTC
Thank-you L~R, I'm still having trouble with gaining the true cell values. I've tried numerous combos pertaing to the cells' function's. i.e. `my $col_name = ref $cell ? $cell->{Val} : '';` [download] I still get the number 0. `my $col_name = ref $cell ? $cell->{Type} : '';` [download] I get output of "Text\|Text\|Numeric" Any help would be great. Thanks! Derek	[reply] [d/l] [select]
Re^3: Spreadsheet-ParseExcel Problem Reading URL in Cell by dperriero (Novice) on Jan 18, 2006 at 21:55 UTC
I'll answer my own question and venture to say I should have RTFM more before I asked anybody. The TODO in the manual says: - Spreadsheet::ParseExcel : Password protected data, Formulas support, HyperLink support, Named Range support. So I guess no HyperLink support yet.	[reply]