Reuben Posted May 15, 2007 Share Posted May 15, 2007 Hi, We have an ERP system and I would like to load data using the ERP's front end. Can Autoit read data from a spread sheet and map to fields on the GUI ? Do you have any examples of this (if this can be done) ? Thanks Link to comment Share on other sites More sharing options...
PsaltyDS Posted May 15, 2007 Share Posted May 15, 2007 What kind of spreadsheet? Check out Excel.au3 UDF for MS Excel. Otherwise it will depend on what programming interface your ERP software provides. 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...
Reuben Posted May 16, 2007 Author Share Posted May 16, 2007 Hi,Any type of spreadsheet would be fine.ThanksWhat kind of spreadsheet? Check out Excel.au3 UDF for MS Excel. Otherwise it will depend on what programming interface your ERP software provides. Link to comment Share on other sites More sharing options...
Shevilie Posted May 16, 2007 Share Posted May 16, 2007 Well imagine that you have a container... And you need a robot to unload it.. Then the robot needs to know how the container works and is made, before it can do it. You cant just make a robot and excpect it to work with any kind of container.. The same with programming. You would have to make a "parser" for each kinda spreadsheet. One for .xsl one for openoffice format etc. Start here if you are new Valuater's AutoIT 1-2-3Looking for an UDF - Look hereDo you need to do it twice - Autoit 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