Forum Discussion

GAutomation's avatar
GAutomation
Frequent Contributor
6 years ago

how to compare the items in the witemlist and the values passed in excel sgould be equal.

we are running a regression with keyword driven framewrok and wanted to write a vb script code to compare list of values in the combobox  that are passed in the excel is matching the witemlist.   ...
  • tristaanogre's avatar
    tristaanogre
    6 years ago

    Actually, you know what, I'd do it in a series of checks... 

    So, it's a dropdown/combo box.  I'm guessing Windows Desktop application.  So, first comparison is to compare the lengths.  If they don't match, don't bother.  Then, once we know the lenghts match, we just go down the line, item by item.

    var excelList = 'x y z';
aqString.ListSeparator = ' ';
if (Aliases.MyApp.MyForm.MyComboBox.wItemCount)  != aqString.GetListLength(excelList)) {
   Log.Error('The list lengths don't match');
}
else {
    for (var i=0; i < aqString.GetListLength(excelList);i++){
       if (Aliases.MyApp.MyForm.MyComboBox.wItem(i) != GetListItem(excelList(i))){
            Log.Error('List item ' + i + ' does not match');
        }
    }
}
tristaanogre's avatar
tristaanogre
Esteemed Contributor

Let's take what you have in the Excel cell... you have the following

x y z

There is a character between these... the space character.  So, this is a list of items with the separator being the space.  Each item in this list can then be iterated in the following way

 

var myString = 'x y z';
aqString.ListSeparator = ' ';
for (var i=0; i < aqString.GetListLength(myString); i++){
    Log.Message(aqString.GetListItem(myString, i);
}

This allows me to cycle through the items in my string and get the individual values.  You can then compare the individual values to individual items in your item list in your drop down control.  Obviously, there's more code to be involved in doing that but this is the basics of using a list of string items.

Technically speaking, you could do something similar in reverse with what's in wItemList.  You just need to know what the ListSeparator character is to make that determination.

tristaanogre's avatar
tristaanogre
Esteemed Contributor
6 years ago

Actually, you know what, I'd do it in a series of checks... 

So, it's a dropdown/combo box.  I'm guessing Windows Desktop application.  So, first comparison is to compare the lengths.  If they don't match, don't bother.  Then, once we know the lenghts match, we just go down the line, item by item.

var excelList = 'x y z';
aqString.ListSeparator = ' ';
if (Aliases.MyApp.MyForm.MyComboBox.wItemCount)  != aqString.GetListLength(excelList)) {
   Log.Error('The list lengths don't match');
}
else {
    for (var i=0; i < aqString.GetListLength(excelList);i++){
       if (Aliases.MyApp.MyForm.MyComboBox.wItem(i) != GetListItem(excelList(i))){
            Log.Error('List item ' + i + ' does not match');
        }
    }
}