How can i get text from excel and seach this text on a dropdown list in an application

Help Forum
1

How can i get text from excel and seach this text on a dropdown list (On adding this variable on the selector)

2

@Soudios

can you tell me more about your usecase

You can try with Read Range activity-> Create a variable for Output in properties

IF you want only one value then you can write as below
VariableName.Rows(RowNumber).Item(Header name).ToString

If you have list of values then use For Each Row activity which will loop into your excel values

Hope this helps you

Thanks

3

@ksrinu070184

i Have this error :

image
image1600×779 26.4 KB

image

I need the process start from cell A5, the first line can be empty, the bot must find the text “SITE ETABLISSEMENT” to start the process on that column
image