Error in WebUI.selectOptionByValue from data file

[daimilamoru2018]

Hi everyone, I’m new using Katalon Studio. I am trying to use the SelectOptionByValue method but the data is in an excel, this is what I am writing but the test fails

WebUI.selectOptionByValue(findTestObject(‘3_BuscarPadron/4_select_Accion’), findTestData(‘Data Files/Proacciones’).getValue(2, 16), false)

Thank you very much in advanced

[Russ_Thomas]

@daimilamoru2018

but the test fails

Details please!

[TIP] How To Help Us Help You!

My test is BROKEN! NOTHING WORKS! HELP ME! Relax. We get it. We really do. There are some pretty smart and clever people on this forum, but you must realize, they are not magicians or wizards or gods. They cannot see your code, they can’t see your errors and they don’t even know what your AUT is meant to do even though it might seem perfectly obvious to you. So please relax and follow the advice below, before you start writing your post. The advice below will tell you the exact information …

[grylion54]

@daimilamoru2018

WebUI.selectOptionByValue

When you use “selectOptionByValue”, it means you have looked at the HTML and seen what the value attribute contains.
If you just looked at the page and seen what the drop-down display is showing, then you need to use “selectOptionByLabel”.

And using either of the two “selectOptionBy” statements assumes you are working on a select tag and not a div.

[daimilamoru2018]

Thank you very much for your answer. Anyway my problem was with the name of data file, the name was: datafile.xls.xls which is incorrect. So i modified the name: data.xls and everything works.