Sign in to follow this  
Followers 0
isdesperado

Copying from excel and pasting it in a web form

4 posts in this topic

Hi,

I am trying to copy each cell in a row from excel and paste the data (one cell to a field) in an internet explorer window.

Eg: Copy a cell from excel and put that in yahoo search box

Once this is done, add a loop to paste the next cell data to the next field

I am very new to Autoit and scripting.

Thanking you in advance.

Share this post


Link to post
Share on other sites



Did you check included help files (and their source code). Look at directories where AutoIT is installed, in ExamplesHelpFile

They are actually quite informative, although sometimes short. But to the point.

You should study f.ex

_ExcelBookOpen.au3

_ExcelReadArray.au3

_ExcelReadCell.au3

_IEFormElementSetValue.au3

Then paste code here in [ autoit ] [ /autoit ] about how far you got.

And.. start with PseudoCode on paper or similar. Structure what you want to do.


I am just a hobby programmer, and nothing great to publish right now.

Share this post


Link to post
Share on other sites

Thank you for your help Myicq.....

But this one went over my head...

I will paste what ever I have done...

#include <Excel.au3>

$oExcel = _ExcelBookOpen("F2315.xlsx")

_ExcelSheetActivate($oExcel,"Sheet1")

_ExcelReadCell($oExcel, 1, 1)

this ran without any issues....

now I want to write a code to paste the values to a ie window with text boxes....then i want to put a loop to cpy the r1c2 from excel and paste it to next box in webpage...there are 10 text boxes on the page pls give a sample code i wil edit and try..

Thank you.....

Share this post


Link to post
Share on other sites

Look at the _IE functions help file. The functions in particular that you'll probably need are _IECreate, _IEGetObjByName (or _IEGetObjById), _IEFormElementSetValue, and possibly _IEFormSubmit.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now
Sign in to follow this  
Followers 0