How to read excel country and insert auto fill in excel

How to read excel country and insert autofill in excel.

Capture

row(“yourColumnName”).ToString this will give you the column values and you can use type into populate it

what choose activities?
row(“yourColumnName”).ToString

in type into

Hi
—use START PROCESS activity and pass the filepath of excel as input to Filename property
—which will open the excel in foreground
—now use a SEND HOT KEY activity with just hot keys and no element chosen
With keys as ctrl+f
—then use type into activity and mention as “COUNTRY”+[k(enter)]” and disable simulate type and enable sendwindowmessage property

—then use another send hot key activity with key as right

—now use one more send hot key with key as ctrl+c

—now this will be copied to clipboard
—use GET FROM CLIPBOARD and assign that to a string variable named str_input

—now use TYPE INTO activity and mention the input at str_input

Cheers @fairymemay

I not understand.
why send hot key (ctrl+f) ?

To go to the creek where COUNTRY value is present so that once after reaching that cell kn pressing right key we would reach its value contained cell

Cheers @fairymemay

—use START PROCESS activity and pass the filepath of excel as input to Filename property
—which will open the excel in foreground
—now use a SEND HOT KEY activity with just hot keys and no element chosen
With keys as ctrl+f

Right ?

Capture

we need START PROCESS activity and not the READ RANGE activity buddy
image

where pass the filepath as input to FileName property

@fairymemay

—use START PROCESS activity and pass the filepath of excel as input to Filename property
—which will open the excel in foreground
—now use a SEND HOT KEY activity with just hot keys and no element chosen
With keys as ctrl+f

Capture

right?

right?

1 Like

You were almost done
First two activities were set perfect while in Type into activity mention as
“country”+”[k(enter)]”

Cheers @fairymemay

I not understand.

1 Like

no changes here buddy

just mention the TYPE INTO activity with this as input
“COUNTRY”+”[k(enter)]”

Cheers @fairymemay

ok.
But i want to copy word (country) in excel —> in web type into country in excelCapture

yah this will take us to the cell with COUNTRY as value then
we are again going to use SEND HOT KEY with key as right
with that we will get to the cell with value CANADA
then these steps

Cheers @fairymemay

How to read column country in excal and i want to autofill web by excel?

https://forum.uipath.com/t/how-to-autofill-web-with-excel-data/185907/4

—use GET FROM CLIPBOARD and assign that to a string variable named str_input
—now use TYPE INTO activity and mention the input at str_input

right?

image

1 Like

Yes buddy
@fairymemay

I copy country but in TYPE INTO not send variable country.