How to copy data from only 1 column and paste it onto web form

hello ive tried using different activities(read range, read cell etc) to copy data from 1 column on a excel sheet but it still doesnt work. i did try using do while loop and it did work but im wondering if there are other alternatives

the web form is something like that

You can also use For-Each loop in this case

Is there any other Manual steps you do if you copy all the data and paste the web form automatically it take? If your Manual steps are like entering one by one, then For-Each will work in this case

Hope this may help you



  1. Use Read Range activity to read the data from Excel file and it will give output as DataTable. Let’s say dtInput.

  2. And then try below expression to read only Qty column.

       dtInput = dtInput.DefaultView.ToTable(False,"Qty")
  3. And then use For Each Row activity to iterate one by one row from dtInput DataTable.

hi thankyou for ur response, may ik where do you put the 2nd step?

i tried for each loop previously but i got stuck as i dont understand exactly how to use it even after watching youtube videos


Use Assign activity.

for the assign part it says this