Reading Currency columns from excel

Help Studio
, , ,
1

In excel I have a table with a few fields (example below)

image
image813Ă—157 5.9 KB

The salary column is of type currency ad the different currencies are defined in the cell types as shown below

image
image925Ă—618 16.8 KB

image
image975Ă—593 17.6 KB

When reading the row from Excel, it appears to know its of type currency but always forces it to Dollars $

See a log of the output

image
image1845Ă—784 60.3 KB

How do you get it to read the currency type from excel not default to $?

2

Hi,

Here is the output:-
image

Please find the attached xaml file.
read currency type forum.zip (9.5 KB)

Thanks

3

This example needs to be done using the modern excel scope as its being developed by a colleague in studiox

image
image879Ă—502 15.2 KB

1 Like
4

Hi Joshua,

This is going to be a workaround, but since UiPath reads the table with a default currency type, maybe you can try “Find/Replace Value” activity first and try to find the currency symbols. And then replace them with the same string that they have. This way, you will overwrite the currency value with a string and the new value is going to be the type of a string. After that, you might read the string as it is.

Hope this helps,

Best Regards,
Kardelen

5

This work around method I’d end up suggesting to update the excel to be a number only and separate field for currency if UiPath can’t read the actual currency type.

Thanks for the suggestion

1 Like
6

@Joshua_Allan_0

Did you try with read formatting display value?

cheers

7

The difficulty there is that the currency will change on different lines and it appears you need to define which currency format so was a dead end

8

@Joshua_Allan_0

if that is the case then from excel you anyways cannot get single format…

you can define rules in your code to identify the current type…by using switch case and check each row for its currency and proceed accordingly

cheers