i have 2 coloumn in on excel sheet , i have to build a bot and find a search for bangladesh taka and take the corresponding rate in coloumn 2 as output.
Please help me to design this bot
Currency Rate
US Dollar 3.6725
Argentine Peso 0.061423
Australian Dollar 2.490844
Bangladesh Taka 0.043308
Bahrani Dinar 9.740346
Brunei Dollar 2.690279
Brazilian Real 0.873054
Please read excel content into a datatable. Then you can use filter datatable activity to get the specific row based on column A (currency) value and extract corresponding column B (rate) value.
Hi
Welcome to uipath community
Hope these steps would help you resolve this
—-use a assign activity like this
str_input = “Bangladesh Taka”
Where str_input is a variable of type string
—use excel application scope and pass the file path as input
—inside the scope use read range activity and get the output with a variable of type datatable named dt
—now use for each row loop and pass the variable dt as input
—Inside the loop use lookup datatable activity
Where mention these property
Input = str_input.ToString
Datatable = dt
Lookup ColumnName = “Currency”
Out Result = str_output
Target column name = “Rate”
Where str_output will be our output
Cheers @senthil.it89
I have developed an activity called “Find”. If finds the value which you are specifying the range or without range. It return the output as string array.