Search in Excel / DataTable

[idolast]

Hi again,

I would like to use QTP to verify whether my application has worked correctly with the data I putted in. Therefore I thought to compare the resulting data with the one, I say it has to be right.
The easiest way to do this would be to compare an Excel-Sheet generated by the application, with the Excel-Sheet containing data I defined.

Now I only want to compare one line in the resulting Excel-Sheet with my Excel Sheet. To find this row I need to search in one column of the sheet for a certain value. In Excel this would be no problem. But with QTP I do not know how to implement this.

I thought it would be good to import both Excel-Sheets into my QTP-test, search for the row and then compare each value in that row the ones of the other sheet.

This works so far. But I did not find a way to really search for a value in the sheet within the DataTable in QTP. For now I did it with a for-statement, iterating through the rows... but this is quite slow...

Is there a function in QTP to search within the DataTable? Or is there a better way to do what I like to do?

Thanks in advance.