W
werwer
Getting help on this one has been tuff, so I'll take it in
steps.
I'm trying to use Excel's (2003) Find() function. This is what I
have so far.
sheets:
foreach my $ws (in $MyWorkbook->Sheets) {
print qq/Sheet $sheetName\n/;
# Can I get a range object and print a value?
my $cell = $ws->Range("A1");
my $ro = $cell->{Value};
print qq/TEST01 cell value $ro\n/;
$cell = $ws->Find('What:="2"', 'After:=ActiveCell',
'LookIn:=xlValues', 'LookAt:=xlPart', 'SearchOrder:=xlByRows',
'SearchDirection:=xlNext', 'MatchCase:=False',
'SearchFormat:=False');
# Nothing here.
$ro = $cell->{Value};
print qq/TEST0102 cell value $ro\n/;
} # sheets:
My 1st question is. Are the arguments to Find being constructed
correctly? Not are these the correct argunments, but is
'After:=ActiveCell'
properly formed. I tried other variations, no quotes, quotes, and
actually assigning a numeric value. Nothing seemed to work.
I've also tried every which way to enter that '2' in What:=
The above doesn't bomb, it just doesn't ever succeed.
Thanks
steps.
I'm trying to use Excel's (2003) Find() function. This is what I
have so far.
sheets:
foreach my $ws (in $MyWorkbook->Sheets) {
print qq/Sheet $sheetName\n/;
# Can I get a range object and print a value?
my $cell = $ws->Range("A1");
my $ro = $cell->{Value};
print qq/TEST01 cell value $ro\n/;
$cell = $ws->Find('What:="2"', 'After:=ActiveCell',
'LookIn:=xlValues', 'LookAt:=xlPart', 'SearchOrder:=xlByRows',
'SearchDirection:=xlNext', 'MatchCase:=False',
'SearchFormat:=False');
# Nothing here.
$ro = $cell->{Value};
print qq/TEST0102 cell value $ro\n/;
} # sheets:
My 1st question is. Are the arguments to Find being constructed
correctly? Not are these the correct argunments, but is
'After:=ActiveCell'
properly formed. I tried other variations, no quotes, quotes, and
actually assigning a numeric value. Nothing seemed to work.
I've also tried every which way to enter that '2' in What:=
The above doesn't bomb, it just doesn't ever succeed.
Thanks