Example excel here [read_only_one_row.xls - Compatibility Mode - Excel] I need the result is only row 2-4 or 3-4 or 4-5 [image] Any tips for this? Thanks

Hi, Can you try to use Take method and Skip method as the following? [image] 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,

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

Help Studio

lovepong66 (Rugpong Sirimart (Luck)) October 11, 2022, 4:32am 5

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

1 Like

Topic		Replies	Views
Extract two rows from data table Studio	6	1974	September 28, 2022
How to read row 2-3 only? Activities excel , activities , question	7	1685	June 13, 2021
How to Extract the Specific Range From the Excel DataTable Studio studio , question , activities_panel	7	1245	February 23, 2023
How to iterate every 10 rows in excel Studio studio , question , activities_panel	15	1432	August 2, 2022
Excel Read Range - last twenty rows only? Studio studio , question , output_panel	5	290	January 7, 2024

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

Related topics