I want to capture the value of 5 different currencies (Euro, GBP, NOK, RON and JPY), convert them to USD and capture their converted values in an excel table. I have used ‘excel for each row’ activity and opened the Chrome browser to capture the data. But the converted values are not being copied to the excel table. Every search for the conversion opens a new Chrome window.
The converted value of the first search is written in the excel table in the corresponding cell but that value is repeated in every other cell.
How do I get the values of all the currencies in the corresponding cells?