How to read each row data and enter into different forms

Help Studio
, , ,
1

Hi,

I have a query in how to read different row data and write it in different application type into box.

Capture
Capture706×119 16.1 KB

each row data into different windows.

2

Hi @Subha_Smita_Patra :wave:

Please follow the below mentioned steps:

  1. Read the input Excel file.
  2. Use a For Each Row activity to iterate through the DT.
  3. Read the values of each row using its column name like row("Data").ToString and store it in a variable.
  4. Use the variable inside your Type Into activity.

Kindly try it and let me know if you are facing any issues.

Cheers!

4
  1. Read the values of each row using its column name like row("Data").ToString and store it in a variable.

I have tried but its giving me error. It is taking column wise in loops but not row wise.
Eg. when Computer is a variable its not taking the value ABCDF

Can i have a sample xaml if possible

5

@Subha_Smita_Patra

Have you tried using a dictionary?

6

Yes tried that method too

7

Did that work?

I’d suggest you go with a dictionary because it’s easier to fetch value for a specific key than iterating it since you are going to enter each row in a different window.

Let me know if you have issues in creating a dictionary from an Excel.

Cheers @Subha_Smita_Patra :slight_smile:

8

It worked by assigning the row values to the variable.
Thanks @monsieurrahul

1 Like
9

That’s awesome @Subha_Smita_Patra :slight_smile:

Kindly mark my response as solution so it would help others!

Cheers!