Downloading values from excel to drop-down list

[sullivanne]

How can I get a value from excel so that the robot selects it from the drop-down list in the browser?
For example, in a cell, in excel, I have the word “name” and I want the robot to select the word “name” from the drop-down list in the browser.
Thank you.

[Marco_Ber (Marco B)]

You can trying using the Select Item activity:

1. Click on the dropdown list in Excel using the ‘Click’ activity.
2. Use the ‘Select Item’ activity to select the option you want from the dropdown list. You can set the ‘Selector’ property to select the dropdown element and the ‘Item’ property to the text of the option you want to select.
3. Click outside the dropdown list to close it using the ‘Click’ activity.

Hope it helps!

[sullivanne]

@Marco_Ber

• Click on the dropdown list in Excel using the ‘Click’ activity.
• Use the ‘Select Item’ activity to select the option you want from the dropdown list. You can set the ‘Selector’ property to select the dropdown element and the ‘Item’ property to the text of the option you want to select.
• Click outside the dropdown list to close it using the ‘Click’ activity.

Thank you, but that’s not the point. I want to fetch cell value in excel to select this value from drop down list in browser. I have a drop-down list in the browser and I want the robot to select the value that is in excel in the appropriate cell.

[stary (Stanislaw R)]

You can try to read excel cell first, saving in “ExcelValue” variable and then using “Select Item” activity pass that variable.

Other way would be to use dynamic selector.