Get data from excel and type into website input field

Help Studio
1

Hi I wanted to get data from my excel and type into the INPUT field of the website while looping.

image
image827×415 25.7 KB

2

Hi,
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?

3

@Vincent_Nuestro,

You can easily do this…

  1. Use Read Range Activity to read data of excel and store in datatable

  2. Use For Each Row Activity to iterate each item datatable contains

  3. Use Type Into or Set Text Activity to write text in website

  4. 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