How to capture currency of different nations, convert it to USD and store it in an excel table?

Help StudioX
, ,
1

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.

Screenshot ref.:
image

How do I get the values of all the currencies in the corresponding cells?

2

Can you please put a picture of your flow?

4

check Properties → Options for Use Browser Chrome card

close : ifOpenedByAppBrowser
Open : IfNotOpen