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 Perl 1 release (18 Dec 2007).

It certainly seems highly likely that Perl 5.10 will be done
before Christmas; there are only very few minor nits to fix
(related to VMS support, and some more exotic platforms).

Cheers,
-Jan

___
Perl-Win32-Users mailing list
Perl-Win32-Users@listserv.ActiveState.com
To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs

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 exist in the affected worksheet, I get 
the following hash error.
 
 
 
Can't use an undefined value as a HASH reference at c:\images\PKSortExport.pl 
line 441, STDIN line 2
 
 
 
 
I could bog you down with the rest of the code, but it might better if someone 
could simply send me a link to the basic code to handle a find failure when 
using Perl to look in a workbook's worksheet for a string.
 
Thank you.
 
 
 
_
Are you ready for Windows Live Messenger Beta 8.5 ? Get the latest for free 
today!
http://entertainment.sympatico.msn.ca/WindowsLiveMessenger___
Perl-Win32-Users mailing list
Perl-Win32-Users@listserv.ActiveState.com
To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs

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:48 PM
To: perl Win32-users
Subject: How to handle a find failure when examining an excel file

 

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 exist in the affected worksheet, I get 
the following hash error.
 
 
 
Can't use an undefined value as a HASH reference at c:\images\PKSortExport.pl 
line 441, STDIN line 2
 
 
 
 
I could bog you down with the rest of the code, but it might better if someone 
could simply send me a link to the basic code to
handle a find failure when using Perl to look in a workbook's worksheet for a 
string.
 
Thank you.
 
 
 

  _  

Are you ready for Windows Live Messenger Beta 8.5 ? Get 
http://entertainment.sympatico.msn.ca/WindowsLiveMessenger  the latest for
free today!

___
Perl-Win32-Users mailing list
Perl-Win32-Users@listserv.ActiveState.com
To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs