How to count the number of rows in DataTable(Excel) which doesn't have Header?

Help
1

Dears,
How to count the number of rows in DataTable(Excel) which doesn’t have Header ? Thx

2

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.

Thanks,
AK

1 Like
3

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

1 Like
4

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.