Beefy Boxes and Bandwidth Generously Provided by pair Networks
Problems? Is your data what you think it is?
 
PerlMonks  

Re: Re: Error getting number of rows in excel.

by cacharbe (Curate)
on Oct 12, 2002 at 03:06 UTC ( #204723=note: print w/replies, xml ) Need Help??


in reply to Re: Error getting number of rows in excel.
in thread Error getting number of rows in excel.

Thanks.

As a matter of fact, I even deal with this very question under the section Finding the Last Column and Row, but I'll reprint it here:
my $LastRow = $Sheet->UsedRange->Find({What=>"*", SearchDirection=>xlPrevious, SearchOrder=>xlByRows})->{Row};

C-.

---
Flex the Geek

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://204723]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others taking refuge in the Monastery: (7)
As of 2016-10-01 19:35 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    How many different varieties (color, size, etc) of socks do you have in your sock drawer?






    Results (6 votes). Check out past polls.