Absent Member.. swostik Absent Member..
Absent Member..
339 views

row count in excel sheet

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

Labels (1)
0 Likes
1 Reply
Absent Member.. Steve_Drummond Absent Member..
Absent Member..

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

 

0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.