OLE Excel Find

2006-12-09 Thread Lukky Perl
I'm trying to find a cell with a specific value. I keep getting the warning: Can't use an undefined value as a HASH reference. Here's the code: my $id = $sheet-Range(A1:A$lastrow)-{'Value'}; for my $paref (@$id){ for my $pa (@$paref){ print defined $pa;

Re: OLE Excel Find

2006-12-09 Thread Mumia W.
On 12/09/2006 04:32 PM, Lukky Perl wrote: I'm trying to find a cell with a specific value. I keep getting the warning: Can't use an undefined value as a HASH reference. Here's the code: [...] Find({What=$pa})-{Row}; [...] Even though $pa might be defined, its content might not be found