Search value into excel document
Posted on 2009-02-23
I want to search for multiple values inside an Excel document.
I have 2 excel files, i open them in Delphi and then get the values of a specific column.
Then i fill 2 memos.
I need to search if :
The memo.lines[from 1- end] exists in Memo2...
The problem with this loop is the time.... The memo lines are almost 20000...
So For 1 to 20000 do
For 1 to 20000 do
Search inside memo2.lines if text exists....
This is too slow.
I'm thinking if there is a way to search using excel commands inside Delphi programmatically...?
Till now i know how to read the value from a cell but i don't know the command (Excel command) to do a fast search inside the document.
Can you think any other solution ?
Thanks in advance.