Blueman Posted April 2, 2013 Share Posted April 2, 2013 (edited) Hey Guys,I was wondering if you can help me with my excel problem.But first i have to know if it is even possible because i don't know how far AutoIT goes in this.I have a application where i need to fill out some values, these values are stored in a excel file and now i have to manually add them into the program. If it is possible i would like to do this automatically with some scripting.In my program i have several rows on each row i have four coloms, i will show you;Number | name | something else | quantityOnly the first colom "Number" is filled the rest is empty. I can navigate through the program using the [TAB] and [ARROW] keys.In my Excel sheet i have also several rows with coloms, i will show you;Number | Details | Base | countNow i would like to set my cursor on the first row in the first colom (from the program) and start the script.- The script will copy the Number to the clipboard- Search in the excel document for the correct row- And then copy the count from that row to the clipboard- And final paste the count into the quantity colomAnd repeat this for the following rows (maybe by pressing the enter button every time a row is done).Do you guys think this is possible and if so can you help me get started?I have experimented with some _ExcelReadArray scripts but didn't work.Thanks Edit:Just starting with a simple IF statement but this didn't work. When i copy something from NOTEPAD to the clipboard it works but when i copy a excel cell (Just through crtl+c) to the clipboard it just keep saying this is a string,.. what am i doing wrong?Local $bak = ClipGet() If StringIsDigit($bak) Then MsgBox(4096, "", "Value contains digits") Else MsgBox(4096, "", "Value is a string.") Send("{LEFT}") Send("{CTRLDOWN}{c}{CTRLUP}") EndIfFixed it! // I just used the StringRegExp function and now it is working Edited April 2, 2013 by Blueman Link to comment Share on other sites More sharing options...
water Posted April 2, 2013 Share Posted April 2, 2013 AutoIt has a builtin Excel UDF (User Defined Functions Library). Check function _ExcelReadSheetToArray to read the whole sheet into an array and then locate and process the needed row. My UDFs and Tutorials: Spoiler UDFs:Active Directory (NEW 2022-02-19 - Version 1.6.1.0) - Download - General Help & Support - Example Scripts - WikiExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example ScriptsOutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - WikiOutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - DownloadOutlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - WikiPowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - WikiTask Scheduler (NEW 2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki Standard UDFs:Excel - Example Scripts - WikiWord - Wiki Tutorials:ADO - WikiWebDriver - Wiki Link to comment Share on other sites More sharing options...
MuchTex Posted April 3, 2013 Share Posted April 3, 2013 Building upon what water said, use _ExcelBookOpen and use that window handle when doing _ExcelReadSheetToArray. I'm assuming the problem you're having is just that. Link to comment Share on other sites More sharing options...
water Posted April 3, 2013 Share Posted April 3, 2013 Or you could have a look at my ExcelEX UDF (still an early Alpha version!). It has a search/find function. My UDFs and Tutorials: Spoiler UDFs:Active Directory (NEW 2022-02-19 - Version 1.6.1.0) - Download - General Help & Support - Example Scripts - WikiExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example ScriptsOutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - WikiOutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - DownloadOutlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - WikiPowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - WikiTask Scheduler (NEW 2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki Standard UDFs:Excel - Example Scripts - WikiWord - Wiki Tutorials:ADO - WikiWebDriver - Wiki Link to comment Share on other sites More sharing options...
Blueman Posted April 5, 2013 Author Share Posted April 5, 2013 (edited) Guys,It worked thanks, but i want to make it some faster by directly getting the data from my WEB MySQL Database.So i have a website with a MySQL database and want to let the script search directly into the database without exporting it to Excel,...Is this possible?Because i have tried to do so, with this UDF; But it keeps saying that it cannot make a connection to my server on several adresses; Localhost, IP from my webserver here on LAN, IP from my webserver on WAN, just the web-adress www.mydomain.nlIt just doesn't work!What am i doiing wrong ? ThanksEDITGuys, don't worry (Be happy? ^^).I got it working!My router was the problem, he didn't transfered the correct MySQL port to the server,. changed it and it works fine!But what i want to know is, how dangerous is it to open your database to the WWW? Edited April 5, 2013 by Blueman 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