Error getting number of rows in excel.

[monir]

Hi,

I am writing a perl script to fetch data from an Excel file.

I used Win:OLE interface. When I go to get the number of rows in the active sheet, I get a large number 55536 (max rows possible), instead of the actual total number of rows.

Here is the snippet I used:

$rowCount = $actvSheet->Rows->{'Count'};

Can anybody help?

Thanks,

-Monir