in reply to Error getting number of rows in excel.

cacharbe has a nice writeup on Using Win32::OLE and Excel - Tips and Tricks.
  • Comment on Re: Error getting number of rows in excel.

Replies are listed 'Best First'.
Re: Re: Error getting number of rows in excel.
by cacharbe (Curate) on Oct 12, 2002 at 03:06 UTC
    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-.

    ---
    Flex the Geek

[reply]
[d/l]

In Section Seekers of Perl Wisdom