How to get the individual row values of the matrix format and write into the excel sheet

activities
studio

#1

The following is the screenshot of the matrix format in the webpage ,

Capture4

And write that data into the excel sheet in the following format,

July 16, 2018, USD, GBP, 1.31593

July 16, 2018, GBP, USD, 0.75992

Thanks.


#2

Have you tried extracting as structured data and seeing what the datatable outputs?


#3

Hi Timk,

Am getting the whole table output as follows,
Capture6

Thanks.


#4

You could try using a for each row - (you know the currency country for each column)

You can build a new datatable with headers (Month / Day / Year / From Currency / To Currency / Rate) and add in the relevant information as you described

So for the first row - it would all be from USD to currency
E.g. USD to USD / USD to GBP / USD to CAS.
Second row GBP to USD / GBP to GBP and so on.

Then simply write that datatable to an excel file


#5

HI TimK, Thanks for the reply. Can you once explain this point you said,

You can build a new datatable with headers (Month / Day / Year / From Currency / To Currency / Rate) and add in the relevant information as you described.

And can you send me the code snippet for “for-each logic”, as I am new to this uipath.

Thanks.


#6

Hi,

I have built out the logic - this is very rough / high level. If you pass in your datatable as above it should produce an output in the format required.:grinning:

If you have any questions around the code, let me know.

Thanks,
Tim
Main.xaml (16.7 KB)


#7

Ok Timk, thanks.