How to read Excel/CSV with German Language Locals? (Comma)

Hi Ivan,

thanks a lot for the fast reply and nice welcome.
The issue with the Umlaut Ä or Ü was due to our source files. Therefore I deleted it in my question to stop confusing other forum users.

The issue with comma and dot is half solved. Just the export to csv ist not working:

Here an example with image and Excel file attached. The first value for “Umsatz” is 56478378,91. The interpreter of the XLS reader node changed it to 56,478,378.91
Then we do some transformations of the table and write the file als Excel or CSV.
In CSV the output is: 5.647837891E7
In Excel it is correct.

image

What would you suggest to make the .CSV export with the right measure format? I tried different Encodings but the result for the measure was the same.

Testdummy.xlsx (10.0 KB)