How to count the number of rows in DataTable(Excel) which doesn’t have Header ? Thx
Hi @hsendel, DatatableName.Rows.Count will give you the count though it has headers or not. Only thing is that you need to uncheck the “AddHeaders” if you do not have header when you Read Range.
Hello @hsendel use excel scop and read range activity… In read range activity enable the add header property…
Read range will return a data table activity
By using below expression you will get the exact count
Count = datatable. Rows. Count
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.