searching excel

[cheeseslice]

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

[water]

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

[Bert]

You may also look into SQLite. It may be faster for what you have in mind.