I have an Explorer folder with many Excel files. My desired process would have to output the number of rows with a certain value (e.g. “done”) from certain files with the same name range (e.g. Booking).
Example:
Booking001 with 10x done
Booking002 with 24x done
Bokking003 with 14x done
…004 8x done
…005 17x done
results after execution = 73
Is that possible?
As the icing on the cake: only count in files from the month “October” (variable)
Is anyone bored designing something like this?
I’ll buy you a coffee
Use the For Each activity to iterate over the elements in filteredFiles
Use Excel Application Scope (workbook path = currentFile.FullName)
Use Read Range activity
Sheet Name - “Booking”
Output: eg. bookingData
Use for each activity for bookingData:
→ use if activity inside to check if the value in the relevant column equals “done” CurrentRow("ColumnName").ToString.ToLower.Equals("done")
Increment counter counter = counter + 1