Sign in to follow this  
Followers 0
villy

Enter the data in excel file into a system

3 posts in this topic

Dear all,

I am new in AutoIT~ I would like to enter the data in excel file into a system user interface.

for example:

excel file's data:

name age

----------------------

ann 25

andy 30

when run on the script, the autoIt will enter the value "ann", "25" then save.

for second time, it take the value "andy", "30" and save again.

Any idea to do it?

Thanks~!!

Share this post


Link to post
Share on other sites



There are a couple Excel UDF's in the example scripts. I suggest you do a search for them.

Share this post


Link to post
Share on other sites

Dear all,

I am new in AutoIT~ I would like to enter the data in excel file into a system user interface.

for example:

excel file's data:

name age

----------------------

ann 25

andy 30

when run on the script, the autoIt will enter the value "ann", "25" then save.

for second time, it take the value "andy", "30" and save again.

Any idea to do it?

Thanks~!!

reading from excel, and working with the data in excel is very easy, as far as taking it somewhere else, 'system user interface' ? could you be more specific?

here's an example to grab the data and send it to a message box, assuming that you only have one workbook open, the active sheet has the data, and the first row is headers as it looks like above. you can use COM to control excel, and open worksheets etc without even displaying them, but i'm not entirely sure what you're looking for. if you offer more specifics, such as file name, worksheet name, what interface data is supposed to be sent to etc, i can give you more targetted assistance.

$myex = ObjGet("","excel.application")
If Not IsObj($myex) Then
    MsgBox(0,"Error","Failed to grab excel object")
    Exit
EndIf
$mywb = $myex.activeworkbook
$myws = $mywb.activesheet
$tmp = ""
$x = 2
While $myws.range("a" & $x).formula <> ""
    $name = $myws.range("a" & $x).formula
    $age = $myws.range("b" & $x).formula
$tmp = $tmp & $name & ' - ' & $age & @CRLF
$x = $x + 1
WEnd
MsgBox(0,"list","These are the names and ages listed" & @CRLF & $tmp)

1100111 00001011101111 00011101101111 00010111100100 00001111110100 00110111110010 00101101111001 0011100i didn't make up this form of encryption, but i like it.credit to the lvl 6 challenge on arcanum.co.nz

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