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??

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};
[download]

C-.

Comment on Re: Re: Error getting number of rows in excel. Download Code

Domain Nodelet^?

Node Status^?

node history
Node Type: note [id://204723]
help

Chatterbox^?

How do I use this? | Other CB clients

Other Users^?

Others making s'mores by the fire in the courtyard of the Monastery: (5)

As of 2023-03-23 08:30 GMT

Sections^?

Information^?

Find Nodes^?

Leftovers^?

Voting Booth^?

Notices^?