RE: How to handle a find failure when examining an excel file

2007-11-27 Thread Jan Dubois
my $range = $Sheet->UsedRange->Find ({What => "ParentItemName", SearchDirection => xlNext, SearchOrder => xlByRows}); if ($range) { my $row = $range->Row; # . } Cheers, -Jan From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Paul Rousseau Sent: November 27, 2007 3:

How to handle a find failure when examining an excel file

2007-11-27 Thread Paul Rousseau
Hello, I want my code to be able to handle the following find statement when it fails to find the text in the 'What' argument. $row = $Sheet->UsedRange->Find ({What => "ParentItemName", SearchDirection => xlNext, SearchOrder => xlByRows}) -> {Row}; If the text, ParentItemName, does not

RE: ActivePerl 5.10 Build 1000 Beta release

2007-11-27 Thread Jan Dubois
On Tue, 27 Nov 2007, David Moreno wrote: > On Mon, 2007-11-26 at 11:00 +0800, Foo JH wrote: > > Now if the final release will only come out before > > Christmas...hee hee > > That's Rafael's goal, AFAICT. There has been some chatter to time the 5.10 release to fall on the 20th anniversary of the P