How to get only row of data in excel

Help Studio
, ,
1

Example data at image below :
excel_exp_0001

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

2

Hi @lovepong66

You can try with filter data table activity

Regards
Gokul

3

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
4

HI @lovepong66

Check this steps

Read range and store in the Dt

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

image
image754×228 8.62 KB

Regards
Sudharsan

2 Likes
5

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

6

Hi @lovepong66 ,

Check Below Xmal

Test.xaml (8.9 KB)

image
image946×646 24.5 KB

Thanks,
Rajkumar

8

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

1 Like
9

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