Find a text in Runtime datatable

[ra.dineshkumar@gmail.com]

Hello Experts,

I need your help.

Could someone tell me how to find a text in the runtime datatable using the code and get the row number of the text?

Here is my scenario: We import the external datasheet into QTP at runtime. That datasheet has more rows and we need to find a text in column A and execution should start from that row. We temporarily have a solution to read each row until we find the text but this consumes more execution time.

I appreciate your help.

Thanks in advance

[supputuri]

Before loading the excel into QTP, get the location of your search string in excel directly and then store it as starting row. Now after loading the excel in QTP, set the starting row and then proceed from that point....