The community will be in read-only from Monday 11:59pm (PT) to Wednesday 7:30am (PT)
The community will be in read-only from Monday 11:59pm (PT) to Wednesday 7:30am (PT)
Operations Orchestration Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

row count in excel sheet

Highlighted
swostik
Occasional Advisor

row count in excel sheet

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

1 REPLY
Steve_Drummond
Frequent Visitor

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

 

//Add this to "OnDomLoad" event