How to read from Excel and use for select item Dropdown value

[Himanshu_Pratap_Rana (Robot Master)]

Hi All,

I am confused in select item activity because i have a dropdown values and read from excel but in excel type value is differ from the dropdown values in Excel(JS MEANS JETSKI).How to use this approach.

This is dropDown Value

this is my excel input

[suraj.setty]

Hi @Himanshu_Pratap_Rana

To use the Select Activity the values should be exactly matching in the excel as well as in the drop down.

Thanks.

[Palaniyappan (Palaniyappan P)]

@Himanshu_Pratap_Rana

JS MEANS JETSKI)

Fine

Let’s standardise the input excel file here
Which means have a separate column at last which will have the actual value for each type and we can choose that value in the list box

So in your excel include a new column atlast and for each type (as in second column) mention the exact corresponding value that we can search in list drop down box

Once included input gets standardised and read that excel file with read range activity and get the output as dt

Now use a for each row activity and dt as input and inside the loop use select item activity and mention the value as CurrentRow(“new ColumnName”).ToString.Trim

So that you can select now the exact value you want

Cheers @Himanshu_Pratap_Rana