How to get only row of data in excel

Example data at image below :

I need to get the result of data by specific row such as … → 3 then result
will be come out like this

ben more canada

Hi @lovepong66

You can try with filter data table activity


Hi @lovepong66 ,

You could try with the below Steps :

  1. Read the Excel sheet using Workbook Read Range Activity, we get the output as a Datatable, say DT.

  2. Next, using the resultant Datatable we can get the values of the required row.

  3. In your case, row 3, In datatable, the indices start from 0 , hence the expression to get the row value would be like DT.Rows(2).ItemArray

  4. Now, to get it into String format, we can use String Join :

String.Join(" ",DT.Rows(2).ItemArray)

Let us know if this doesn’t work or is not the expected output.

1 Like

HI @lovepong66

Check this steps

Read range and store in the Dt

String.Join(" ",Dt.Rows(0).ItemArray)



You need to change the number as per the row you need @lovepong66

Hi @lovepong66 ,

Check Below Xmal

Test.xaml (8.9 KB)


That’s exactly what I want. Thank you very much.

1 Like

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