Dear masters ,How to retrieve all data from Dropdown and paste in excel with out duplicates

Help Studio
, ,
1

How to retrieve all data from Dropdown and paste it into excel without duplicates.

2

Hey @lakshmi_narayana_ch

You can try the below,

  1. Find Children - Get all the options in the dropdown as a string collection

  2. Build DataTable with one column - dt_Output

  3. Just find the distinct values from it & convert to datatable - strListValuses.Distinct().Select(Function(obj) dt_Output.Rows.Add({ obj })).CopyToDataTable

  4. Write Range - To write the DataTable into the Excel

Hope this helps.

Thanks
#nK