Data from excel to web

[orna_maf]

hi ,
I didn’t find any resource for insert to web form data from excel.
I use the studio.

i choose the excel application scope, this ok ?
if yes where I put the url of the website?

[Palaniyappan (Forum Leader)]

Hi
Welcome to uipath community
Hope these steps would help you resolve this
—use excel application scope and pass the file path as input
—inside the scope use READ RANGE activity and mention the sheetname as input and get the output with a variable of type datatable named dt
—now use a FOR EACH ROW activity and pass the variable dt as input
—inside the loop use a OPEN BROWSER activity and mention the url we want
—then to input the values from excel mention as row(“yourcolumnname”).ToString in type into activity
So that it will type the value from a column row by row for each iteration
Where row is the variable from for each row activity

Cheers @orna_maf

[orna_maf]

Hi,
thank you for your answer.
but I still have a problem, I follow all the instructions above.

[Palaniyappan (Forum Leader)]

Hi
kindly get the cursor to that blue mark near to URL in open browser activity so that we will get to know the error we have
Cheers @orna_maf

[cmolina (Carlos Molina)]

His url is not in between quotations
@orna_maf it is a good practice to check that kind of validation messages

[orna_maf]

Thanks ,
one error was “quotations” after @cmolina advice I solve this error.
another error is :Error ERROR Activity is valid only inside ExcelApplicationScope test1.xaml
I’ not sure that I understand whats wrong ? what I miss?
Thanks

[cmolina (Carlos Molina)]

There are some activities only valid inside an ExcelApplicationScope. They are under App Integration > Excel, not System > File > Workbook.

Just check exactly which one is causing the error.

[orna_maf]

I dont see any problem , expect above ,
maybe its located the wrong place?

[cmolina (Carlos Molina)]

Which activity exactly is throwing the error?

[orna_maf]

hi, I follwing all the above .
but I got the error

BlockquoteError ERROR Compiler error(s) encountered processing expression “row(“mail”).ToString”.
‘row’ is not declared. It may be inaccessible due to its protection level. test1.xaml
where I declared row?
this all what I did

[sai_prasanth]

Hi @orna_maf,

Can you cut your open browser and its following sequence and paste it into the body of for each loop. By your SS itseems you are trying to call the row in for each outside its scope.

Cheers,
Saiprasanth

[orna_maf]

hi,
its work but without submit,
its fill the web form but not submit.
the web form compose from 2 field
Email field and Submit field
my question is how I add to my task a the submit action
anther question I notice that during the run the system open the browser
a lot of time. how it can close the browser afther the task?