How to select dropdown value according to the value on Excel sheet... Please help

I’m trying to read data from Excel and append that value on drop down selection xpath. It’s not working properly
Please help me to select the value from drop down according to the Excel sheet value

I have tried the code above. I have to append variable that have a value from excel sheet.

on webdriver eg: //span[contains(text(),’"+variable+"’)] we can append variable like that

Hello,
You don’t use the selectOptionByLabel function correctly.

It’s

WebUI.selectOptionByValue(findTestObject('_path of select object_'), '_value_', false)

You can use a variable for the value and after that bind the value with the excel sheet.

@sayoojnexquare @HeleneB
Were you able to resolve it ?
Have used below code unfortunately it dint work
WebUI.selectOptionByValue(findTestObject(‘Object Repository/Web/span_Tanzania’), findTestData(‘data’).getValue(‘SelectCountry’,
1), true, FailureHandling.OPTIONAL)

The syntax looks good.
Does it have any error message ?

list of countries

@HeleneB
It is in list
No signature of method exception

You can not use WebUI.select[…] keyword on a ul HTML tag. Use click instead