On Tue, 18 Dec 2001, Luba Sereb wrote:
> $Cells = $Sheet->Range("A$iCell");
> $Cell = $Cells->{Value}; #get the contents at
>
> When script find empty cell it send message: "Use of
> uninitialized value in string ne at...."
> and program finished.
>
> What problem is? How to avoid this problem.
Assuming you're using Spreadsheet::ParseExcel? You need to check the
return values in these two lines before you try to use them elsewhere.
Excel completely eliminates truly empty cells when you save the file (FYI
Spreadsheet::WriteExcel does not behave this way), and
Spreadsheet::ParseExcel returns undef if you try to access them.
Steve
_______________________________________________
Perl-Win32-Users mailing list
[EMAIL PROTECTED]
http://listserv.ActiveState.com/mailman/listinfo/perl-win32-users
