Uipath overdrives Excel file Locale configuration

Help
1

Hi guys

I have to process some excel files that comes with an specific Numeric format that is es-CL
that has dots as a thousand separator and comas as decimal separator
Thousand separator = 100.000.000
Decimal= 1.000.000,1213
When i use any of the excel activities the numbers inside the excel change their format and leaves them like this

Before: 13.640
After:13,64

the thousand separator becomes a coma and the 0 is erased.
I already tried the “Preserve Format” option and i get the same result.
Is there a way to change the locale of the excel activities, if it not, what are my options?

1 Like
2

Fine
Concatenate with a single quote before the current value in the datatable and then enter that value in the excel
Like use a for each row loop and pass the above datatable variable as input
—inside the loop use a assign activity like this
row(“yourcolumnname”) = “‘“ + row(“yourcolumnname”).Tostring

Now pass this as a input to the excel
This won’t change the format

Cheers @brandon_araya

1 Like
3

Hi,

It kinda works.

now the comas are gone but the 0 at the end of the numbers still disappear

Regard

Brandon