LuK12 Posted January 31, 2012 Share Posted January 31, 2012 Hi Guys, I am pretty new to AutoIt, However i have managed to create a few scripts, so i know the basics. My next task is to create a script that would allow me to search a column of a spreadsheet, For every cell within that column that has the keyword being searched for in it. I would like to copy the entire row, from the same line as the cell with the desired keyword. Lastly i would like to paste the row onto a new spreadsheet, allowing me to see all of the rows with the same; Manufacturer, Supplier, Part No, Ect. So there will be more than one result for every search. I would also like to achieve this by using a GUI with different search options in it. Would it be possible for someone to point me in the right direction of what i need to read up on, to do this kind of script. Thanks Link to comment Share on other sites More sharing options...
water Posted January 31, 2012 Share Posted January 31, 2012 The Excel UDF (User Defined Functions) that comes with AutoIt isn't very good at searching but can do the rest.There is an extended available. Function _ExcelFindInRange will help you here.Or you can access Excel like a database and use "SELECT" statements etc. Start for this approach. Or search the forum for "excel ado select". 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...
LuK12 Posted January 31, 2012 Author Share Posted January 31, 2012 Thank you for the push in the right direction. It is truly appreciated. 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