Sign in to follow this  
Followers 0
Ghduo

Is my AutoIT idea implementable?

3 posts in this topic

Hello,

I have an idea for a program that would be very helpful but I am not sure if AutoIT would be able to perform what I need it to.  I'm not very familiar with AutoIT but if my idea could work, I am willing to put in the time to make it work, and any tips or help towards that would be great :D

I work in a type of data entry environment.  My job is to open up files using a program, we will call "workpiece", manually edit some numbers in window boxes, then save the new file, ad infinitum.  I get my numbers from these enormous sheets of paper which is an excel sheet with 4 columns that they have printed onto that paper.  The first column is the item number I need to enter into workpiece, the 2nd column is an operation number that I need to find and select in workpiece, the third column is the current number value stored in workpiece and the 4th column is the new number that needs to be entered into workpiece.  Essentially the entire process is mouse movements, mouseclicks, keystrokes, and reading the numbers from my excel chart.

I've seen that there are AutoIT functions that can handle the mouse movements, clicks, and simulated keystrokes.  Is there a function that could automatically read from the excel file if I input that actual .xlsx file, and copy paste the information stored in the cells into specific windows in workpiece?  

I appreciate any help or comments regarding this, thank you for reading it.  Please let me know if there is more information that you need, and I will do my best to provide it

Share this post


Link to post
Share on other sites



AutoIt can do that  ... search for Excel in the AutoIt help files.

Share this post


Link to post
Share on other sites

AutoIt comes with a builtin Excel UDF (User Defined Functions). If you have problems with the xlsx file format then my alpha version of the new Excel UDF might help.


My UDFs and Tutorials:

Spoiler

UDFs:
Active Directory (NEW 2017-04-18 - Version 1.4.8.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (NEW 2017-02-27 - Version 1.3.1.0) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (2015-04-01 - Version 0.4.0.0) - Download - General Help & Support - Example Scripts
Excel - Example Scripts - Wiki
Word - Wiki
PowerPoint (2015-06-06 - Version 0.0.5.0) - Download - General Help & Support

Tutorials:
ADO - Wiki

 

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