Well, you're asking for the number of rows in the sheet, and that's what it's giving you.

Do you mean you want only rows with something particular in them? Then you either need to loop through the region looking for that something particular, or define a region that you're interested in and count the rows in that.

In other words, all the work is in understanding the Excel object model and how the methods and properties work -- it has little to do with Perl or Win32::OLE. If you haven't already, go to http://www.roth.net and read up.