Data loss while extracting data from a .xls file an converting it to a xlsx

Hi guys,

So I’m Using Excel activities to exctract the data from an xls file using read range and then creating a new xlsx file with the extracted data table the problem is that because of a problem with the thousand separator (in my case dots) that become comas and the int values get truncated and treated as float

Example
XLS

A1
11.630
50.000
2.304

XLSX
A1
11,63
50
2,340

Is there a way to fix this?

hello @brandon_araya

while reading the file Enable the Preserve format property and check once.
image

it might help you.

Regards
Ajay

1 Like

Hi
i tried that but it still changes the numbers from int to float and truncates them.
i had the same problem while using the English (US) language on windows and opening a similar excel file, i open it with excel and the numbers where all decimals all of a sudden, i fixed changing the Language to spanish (Chile)

Regards
Brandon

hello @brandon_araya

then you need to change the region and language setting in your windows.

i guess based on the region and language settings currency also changes.

if you already solved it,congrats :slight_smile:

have a nice development

REgards
Ajay