How to fetch the dropdown values from excel

Help Studio
, ,
1

Folks,

I 'm facing some challenge i would appreciate if anyone could help me out

I have a dropdown in excel , please check the screenshot

image
image1515×889 57.5 KB

I want to get all these values from the drop down

Thanks in advance

2

Hi @rsr.chandu

You need to use combination of activities to get the dropdown values

  1. Click on the drop down
  2. Point the list as source in Find children activity

Excel Combo Box 2
Excel Combo Box 21920×780 72 KB

  1. In the filter section provide <ctrl role='list item />’

Excel Combo Box 3
Excel Combo Box 31501×775 41.9 KB

  1. Loop through the list of Ui Element from the output of Find children activity
  2. Use Get Attribute activity and select ‘name’ as the output attribute.
  3. Add the output to list or data table

Thanks
John

3

Hello @rsr.chandu

Did you try the Select item activity in UiPath?

Thanks

4

Hi @rsr.chandu

My previous answer did not work correctly. I faced selector issue with find children activity. so here is another approach to get the drop down values

  1. Using Get Attribute activity retrieve the text value
  2. Add the output to list or data table
  3. Press down arrow key and perform step 1 and step 2
  4. Repeat the steps until all the drop-down values are retrieved

I have attached the sample workflow

Excel Combobox 1.xaml (17.7 KB)

Thanks
John

5

Hi @rsr.chandu ,

Can you take a look on this ?

Thank you
Balamurugan.S

6

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.