Get data from website

Help
1

In the following website ‘https://www.x-rates.com’ , have the following calculator where I need to click some fields and get the result,

First input box is selected,

xrates2
xrates2857×331 21.8 KB

Second Input box should be selected,

xrates3
xrates3802×416 37.7 KB

If I have the following currency combination, (EUR,USD) then I need to click the EUR from the first input box, USD in the second input box then should click the first input box, copy the calculation from the side and paste into the excel sheet as the following manner,

excel

Can I know for the above functionality, which activities are need to be used!?

Thanks in advance.

2

Hi Sumitha - You can use the web recorder feature in UiPath, where you can perform the action which you mentioned and even you stop the delay of the recording my pressing F2 key.
You can go through the video for reference : RPA Video Tutorials | UiPath

3

Use select item activity to select values
Else you can also use type into and hit enter
Then use get text from where you need to copy the data

4

Hi @pruthvisiddhartha thanks for the reply,

The combinations of Currencies will be changed dynamically based on the user requirement, we will enter the user requested currencies first in this excel list,

list
list1046×234 8.47 KB

Then after reading above excel sheet, the program should run and enter the currencies in the two input boxes in the website,mentioned above .

And write the combinations of currencies as below,

excel

So, is the recording will be suited to this requirement!?

5

Hi Sushmitha - You can very well achieve this by the recording feature, but need to make couple of changes to the selectors.Recording will only help in building up the skeleton of the process.

  1. As per you requirement, you have to use Excel Activities, Type Into Activity, Get Text Activity, For Each Row Activity[if there are couple of records.].
    PS : If the currency conversion code[like, USD&INR] if are in different cells, it would be easy to get the data from Excel.
6

Ok , but the currencies will be in the same column @pruthvisiddhartha.

7

Hi Susmitha - In that case you have the split the string using split function.

8

string2

As above function @pruthvisiddhartha!?

9

Hi Sushmitha - Yes, and also you can use Assign activity to store the values.

10

Ya @pruthvisiddhartha, but previously used the below functionality for getting the data from the matrix format
matrix

In the following xaml, CurrencyExchangeNew.xaml (21.0 KB).

Does the above functionality in xaml suits for " reading from excel sheet, the program should run and enter the currencies in the two input boxes in the website and write in the excel sheet with the combinations of currencies"

11

Hi Susmitha - Will check and let you know if there is anyway to do that, because i have not come across such scenario yet.

12

ok @pruthvisiddhartha.

13

Hi @Divyashreem - Any suggestion that you can help with as well.

14

Hi Sushmitha - And in the mean while if you find any solution, please let me know as well,

15

Sure.