Values in Excel Cells

henry m has asked for the wisdom of the Perl Monks concerning the following question:

I am 'reading' an Excel spreadsheet using $$ref_cell_array = $worksheet->range($excel_data_range)->{'value'}; The spreadsheet has been prdcued by another person. Even though the cell is empty I sometimes find that my Perl applciation 'thinks' that the cell has a '0' in it. How do I prevent this happening?

Comment on Values in Excel Cells

Replies are listed 'Best First'.
Re: Values in Excel Cells by duff (Parson) on Nov 14, 2003 at 15:56 UTC
You should probably check for a defined value before using whatever you get. But I don't know. You didn't give enough problem context for anyone to be more helpful. duff	[reply]
Re: Values in Excel Cells by Theo (Priest) on Nov 14, 2003 at 20:13 UTC
If I were having that sort of problem, I would create my own SS that I could fill with various numbers, text and formulas to see if I could reproduce the problem. Some formulas may not result in an actual number, but the presence of the formula in the cell might give an odd result. YMMV -theo- (so many nodes and so little time ... ) Note: All opinions are untested, unless otherwise stated	[reply]