TestProject Forum

Way to fetch number of rows from the excel sheet

How can I find the count of data rows from excel sheet?

Hi @RajatSehgal,
You can use the action Read Excel Column and put returned value in a parameter,

Then use the action Count Strings and output of the action will return number of rows.

Please let me know if you managed.