Hi all,

I'm trying to catch errors in a small excel driver script I've got.
Essentially, we parse a text file, take the values and stuff them into
named cells in a template spreadsheet, calculate, then save off the output
and loop to the next line in the text file.

I have a problem when occasionally someone adds a new template xls to the
mix and forgets to name all the appropiate cells correctly.  This results
in an error I seem unable (or too ignorant) to prevent... any help?

Assume cell "FRED" is not defined.

$sheet->Range("FRED")->{Value} = "foo"

my script dies with the following:

Can't use an undefined value as a HASH reference at E:
\denap\Perl\Excel\test.pl line 16.

thanks,
-Tom

_______________________________________________
Perl-Win32-Users mailing list
[EMAIL PROTECTED]
http://listserv.ActiveState.com/mailman/listinfo/perl-win32-users

Reply via email to