row count in excel sheet (104 Views)
Reply
Occasional Contributor
Posts: 5
Registered: ‎12-10-2012
Message 1 of 2 (104 Views)

row count in excel sheet

how can get the count of the number of rows in an excel sheet

Trusted Contributor
Posts: 89
Registered: ‎10-01-2012
Message 2 of 2 (96 Views)

Re: row count in excel sheet

Hi, 

 

You can use the operation /lib/op/filesystem/windows only/excel/Get Row Index by Condition.

 

You will need to choose a column which will contain the most amount of row data (or loop through all your columns) and use that as the columnIndextoQuery.

 

Then set operator to != and set value to Use Constant. Add a result field from output field rowsCount.

 

This will return  a count of rows up to the last row found in that column which has data. However, it won't consider any blank cells in that column up to the last row; if you need to count the blank rows as well you will need to use the operation again but this time set operator to be ==. You can then add the two results together.

 

Hope that helps.

 

cheers

steve

 

The opinions expressed above are the personal opinions of the authors, not of HP. By using this site, you accept the Terms of Use and Rules of Participation.