Re: Spreadsheet::WriteExcel write failure

Replies are listed 'Best First'.
Re^2: Spreadsheet::WriteExcel write failure by adolpht (Novice) on Jan 11, 2005 at 12:36 UTC
Hi John and rdfield, write returns 0 if successful so of course my code will fail,... if write is successful. Dho! $! being set to "No such file or directory" is an intersting red herring Thanks for the feedback guys Cheers Tony	[reply]
Re^3: Spreadsheet::WriteExcel write failure by gellyfish (Monsignor) on Jan 11, 2005 at 12:39 UTC
The `$!` being set like that is often a result of the searching through @INC for a file to be used or required. /J\	[reply] [d/l]
Re^4: Spreadsheet::WriteExcel write failure by adolpht (Novice) on Jan 11, 2005 at 12:54 UTC
Oh ok... thanks for the info.	[reply]
Re^3: Spreadsheet::WriteExcel write failure by Errto (Vicar) on Jan 12, 2005 at 05:19 UTC
A couple of things to note: most modules do not set the variable $! on failure. For example, DBI sets the variable $DBI::errstr for class method errors, and $dbh->errstr for errors concerning a specific database handle. Also, you really have to look at the docs for each module to determine whether a particular method returning undef or false means that the method failed. Generally this will only be true for methods whose return value is specified to have a certain meaning. Spreadsheet::WriteExcel's write method appears not to be one of them. Finally, you have to be careful because unlike $@, $! is not guaranteed to contain a blank string or other false value when no error has occurred, so its value is essentially unpredictable in those circumstances. See perlvar for details.	[reply]