Hi I wanted to get data from my excel and type into the INPUT field of the website while looping.
I’m afraid I don’t understand your question.
If you want to know how to do it I would do the following:
- Read Range → Save to Datatabel
- Loop over Datatabel → Get-Item Activity for the corresponding column (if you did not restrict ReadRange)
- Input into the corresponding field
Does this help you?
You can easily do this…
Use Read Range Activity to read data of excel and store in datatable
Use For Each Row Activity to iterate each item datatable contains
Use Type Into or Set Text Activity to write text in website
Provide below code to step 3 activity
row(“FOR BOT’S ENCODING”).ToString.Trim
It will write in website until datatable runs out of records