How to read excel country and insert autofill in excel.
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 ?
we need START PROCESS activity and not the READ RANGE activity buddy
where pass the filepath as input to FileName property
—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?
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 excel
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?
1 Like
Yes buddy
@fairymemay
I copy country but in TYPE INTO not send variable country.
prashant1603765
V_Roboto_V
ashokkarale
mively
Yoichi
ppr
arivu96
Darshan_Sable
Anil_G
Chris.ro