Comapre if the values in the excel & Combobox list
I wanted to how to code in QTP that is to Check if the values in an excel are present in the Combo Box list.
The example is the sample of flights application,
if i have a combobox FLYFrom and in excel sheet i have London as the value to check i want the code to show that this value exist.
Here i want to specify that the values in the excel are not in the same sequence as that of the Combobox list and are not of equal numbers that is the row count.
Re: Comapre if the values in the excel & Combobox list
What code have you tried so far?
Re: Comapre if the values in the excel & Combobox
Lora, Search the forum for Excel.Application to see how you can work with excel sheet to read the info. Or you can also import it to DataTable and then read it.
Then you need to use GetROProperty("all items") on the list and use a Split to get the array from it. Then you need compare the array with the values you retrieve from the sheet. The logic is all in front of you, all it needs is just a effort from your side.