cheeseslice Posted November 17, 2009 Share Posted November 17, 2009 Hello, I am about to start writing a script that will find a value in a spreadsheet and extract the entire row that the value is on out of the spreadsheet into a gui. I was just wondering, before I start, if anyone that has done this before could give me a bit of advice. Am I better to load the entire sheet into memory as an array and search that or would it be more efficient to use readcell and loop through the columns? The data I will be looking for will be a surname then firstname, I will then extract a set of 10 figures for this person when. If I use readcell it will search column A for surname then if I get a match it will check the firstname in column B before extracting the data. The workbook will contain 9 sheets with a maximum of 130 rows of data per sheet. Thanks Link to comment Share on other sites More sharing options...
water Posted November 17, 2009 Share Posted November 17, 2009 (edited) Please have a look at the extendet ExcelCom UDF (_ExcelFindInRange). It has more features then the Excel UDF that comes with AutoIt. Edited November 17, 2009 by water 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...
Bert Posted November 17, 2009 Share Posted November 17, 2009 You may also look into SQLite. It may be faster for what you have in mind. The Vollatran project My blog: http://www.vollysinterestingshit.com/ 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