in reply to Re: Error reading Excel Cell Value
in thread Error reading Excel Cell Value
Were that the case I'd expect he would be getting an error trying to call the method Value on an undefined value (at least a quick test referencing a cell from an empty sheet in an existing xls file returns undef for me and $sheet->{Cells} is an arrayref with the 0th item being an empty arrayref (so [ [] ])). Never the less you might want to sanity check your indexen versus $sheet->{MaxRow} and $sheet->{MaxCol} (and/or the minimums if you're truly paranoid :), and also check that you've got a defined value before attempting to manipulate it.
my $value; if( my $cell = $sheet->{Cell}->[$r]->[$c] ) { $value = $cell->Value(); }
The cake is a lie.
The cake is a lie.
The cake is a lie.
|
|---|
| Replies are listed 'Best First'. | |
|---|---|
|
Re^3: Error reading Excel Cell Value
by sandeep78 (Novice) on Oct 03, 2008 at 22:17 UTC | |
by ggvaidya (Pilgrim) on Oct 06, 2008 at 04:02 UTC |