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

awaisji2001 (Awais Ali Qamar) October 11, 2022, 3:52am 2

Hi @lovepong66.

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

Regards
Awais Ali Qamar

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