How do i get result of specific rows range by using 'Read Range' in Activities

[lovepong66 (Rugpong Sirimart (Luck))]

Example excel here

I need the result is only row 2-4 or 3-4 or 4-5

Any tips for this? Thanks

[awaisji2001 (Awais Ali Qamar)]

Hi @lovepong66.

You just use the range from the 2A:4C.
Hope this will works for you.

Regards
Awais Ali Qamar

[Yoichi]

Hi,

Can you try to use Take method and Skip method as the following?

The following return 3-4 because row 2 is skipped by Skip(1) and return 2 rows by Take(2)

dt.AsEnumerable.Skip(1).Take(2).CopyToDataTable()

Regards,

[lovepong66 (Rugpong Sirimart (Luck))]

100% working for me. Thanks

Details
dt.AsEnumerable.Skip(1).Take(2).CopyToDataTable()

and
Newtonsoft.Json.JsonConvert.DeserializeObject(Of Newtonsoft.Json.Linq.Jarray)(Newtonsoft.Json.JsonConvert.SerializeObject(dt))

[lovepong66 (Rugpong Sirimart (Luck))]

I tested on it but nothing come out. by the way thank you very much for your reply.