Hello to all.
I'm new with Autokey.
I need help to copy data from excel cells to web browser fields.
To better explain:
I have spreadsheets with data, I need to copy all of this data on consecutive fields in the web browser (I use chrome). I can select them all together, because they are on the same column.
My idea is to use a hotkey to copy the column, then I move on chrome and i can use another hotkey to paste on different and consecutive fields.
Please Help
guiduz
help to copy data from excel cells to web browser fields
Re: help to copy data from excel cells to web browser fields
All depends on
1) What youre spreadsheet looks like
2) What the website looks like
1) What youre spreadsheet looks like
2) What the website looks like
Re: help to copy data from excel cells to web browser fields
I need only to know how to paste some data (that i have copied from excel), to the fields of the web page.
I would copy the (for example) 10 cells in excel, and then, i would paste on the web page fields, as if i pres tab between every data.
I hope i explained.
Thanks
I would copy the (for example) 10 cells in excel, and then, i would paste on the web page fields, as if i pres tab between every data.
I hope i explained.
Thanks
- Blackholyman
- Posts: 1293
- Joined: 29 Sep 2013, 22:57
- Location: Denmark
- Contact:
Re: help to copy data from excel cells to web browser fields
Code: Select all
send ^c ; copy
Winactivate, browserWinTitle
Send ^v ; paste
Sleep 200
Send {tab}
WinActivate, excelWinTitle
Courses on AutoHotkey
My Autohotkey Blog
Re: help to copy data from excel cells to web browser fields
First of all thanks for the help!
I try to explain.
I would manually select and copy the cells in excel, using ctrl + c.
Now I have in the clipboard the list of data that I need to paste in different fields on the browser, one by one.
At this point I need a macro that, after placing the cursor on the first field, by pressing a button, it will paste the data that I have in memory, one by one, in the browser fields, consecutively one by one (the first in the first field, the second in the second field...and so on) (As if I did ctrl + v to paste the first data, and then I press the tab key to move to the next field, then press ctrl + v, for the second data, etc.)
Thanks a lot
guiduz
I try to explain.
I would manually select and copy the cells in excel, using ctrl + c.
Now I have in the clipboard the list of data that I need to paste in different fields on the browser, one by one.
At this point I need a macro that, after placing the cursor on the first field, by pressing a button, it will paste the data that I have in memory, one by one, in the browser fields, consecutively one by one (the first in the first field, the second in the second field...and so on) (As if I did ctrl + v to paste the first data, and then I press the tab key to move to the next field, then press ctrl + v, for the second data, etc.)
Thanks a lot
guiduz
- Blackholyman
- Posts: 1293
- Joined: 29 Sep 2013, 22:57
- Location: Denmark
- Contact:
Re: help to copy data from excel cells to web browser fields
Code: Select all
loop
Courses on AutoHotkey
My Autohotkey Blog
- Blackholyman
- Posts: 1293
- Joined: 29 Sep 2013, 22:57
- Location: Denmark
- Contact:
Re: help to copy data from excel cells to web browser fields
Code: Select all
clipsave := clipboard
Loop, parse, clipsave, `n, `r
{
Clipboard := a_loopfield
Send ^v
Sleep 200
Send {tab}
}
Courses on AutoHotkey
My Autohotkey Blog
Re: help to copy data from excel cells to web browser fields
And how can i use the code?
sorry, i'm really new
sorry, i'm really new
Re: help to copy data from excel cells to web browser fields
This code copies an entire row of Excel data into one single field.
How to make jump by cells, not entire rows?
How to make jump by cells, not entire rows?
Re: help to copy data from excel cells to web browser fields
HelloBlackholyman wrote:Code: Select all
clipsave := clipboard Loop, parse, clipsave, `n, `r { Clipboard := a_loopfield Send ^v Sleep 200 Send {tab} }
Can someone give a help, this script works so great that make me a lot of time save but i need some improve.
I can copy one column from exel to copy into www field (some kind of data base in my company) but when i copy 2 column or more i want to script take that 2 column as 1 long one and when one end it should take data from next one. Now script copy row with data from column 1 and 2 and second row with column 1 and 2 etc...
So i need to copy few column in exel and copy into www field same way as script do but one by one and when first column end it should start copy data from next and then from 3 and so.
Thanks if someone give me a some help