Excel integration


#1

I want to pick up data from excel and use that to fill up a form of a website. Please tell me how can that be done?


#2

Hi,

1.open excel using Excel application scope activity
2. Use Read Range activity to read all the data from excel and store it in data table
3.Use For each row to iterate though all the item.
4. Use Get row item activity inside For each row loop to get specific value from each column.
4. Use Open browser activity to launch the site and use recoding to fill the form.
5. Pass the "Get row item" output variable to the type into activity depends on the field.

For demo
check this out.


#3

What do we write in the row property of the Get row item activity?


#4

@sanap Provide ForEach variable in the row property of the Get row item activity.
For Example the syntax of Foreach row is
"ForEach row in dt " where dt is datatable of read range activty & row is foreach variable so provide row in the row property of the Get row item activity.

let me know if any concern