dm83737 Posted February 7, 2009 Share Posted February 7, 2009 This is probably somehwere in here, but I am just not wording my search correctly. I am pretty new to AutoIt, and it's great. I have past experience with Quicktest Pro from a past job, and one thing I am trying to use AutoIt for is the same type of task QTP did. We set up QTP to run a script and then whenever we had to enter an account number, it pulled from an excel spreadsheet and kept doing this in a loop until all policy numbers were exhausted. Is there a way to set this up in AutoIt? Again, I have a feeling this is real easy for all you seasoned vets, I just haven't looked in the right place yet. Thanks for your help Link to comment Share on other sites More sharing options...
dm83737 Posted February 7, 2009 Author Share Posted February 7, 2009 I forgot to add that if there is a better way other than through Excel, I would love to hear that as well. Link to comment Share on other sites More sharing options...
PsaltyDS Posted February 7, 2009 Share Posted February 7, 2009 This is probably somehwere in here, but I am just not wording my search correctly. I am pretty new to AutoIt, and it's great. I have past experience with Quicktest Pro from a past job, and one thing I am trying to use AutoIt for is the same type of task QTP did. We set up QTP to run a script and then whenever we had to enter an account number, it pulled from an excel spreadsheet and kept doing this in a loop until all policy numbers were exhausted.Is there a way to set this up in AutoIt? Again, I have a feeling this is real easy for all you seasoned vets, I just haven't looked in the right place yet.Thanks for your helpYou could do it easily with the _Excel* functions of the Excel.au3 UDF (see the help file).An .xls file can also be opened and read as a DB by an ADO.Connection object (I think ptrex posted an example somewhere). Valuater's AutoIt 1-2-3, Class... Is now in Session!For those who want somebody to write the script for them: RentACoder"Any technology distinguishable from magic is insufficiently advanced." -- Geek's corollary to Clarke's law Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now