Count Rows in Datatable

[caoshixiao]

Hi all,

I’m trying to read an Excel table like below

After I read the table and use “rows.count” to count. The output was 2 instead of 3.
My aim is to get 3 rows in the datatable. Anyone help me plz

Thanks & Regards,

[lakshman (Ganta lakshman)]

@caoshixiao

I guess you checked AddHeaders option in Read Range activity. Uncheck it and then try once.

[caoshixiao]

I guess you are Right. Thanks a lot!