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
Is there a way to fix this?
while reading the file Enable the Preserve format property and check once.
it might help you.
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)
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
have a nice development