@clemensb I couldn't reproduce your issue in FME 2020 or 2019. See the attached spreadsheet, sheet2 for my example. variousencodings.xlsx

What version of FME are you using? What system locale is your machine set too.

i am using FME(R) 2019.1.0.0 (20190710 - Build 19608 - WIN64) with Windows 10

the system locale is "Deutsch (Deutschland"

i got the same problem with your .xlsx, preview is fine, imported is wrong

I was also unable to reproduce the issue - aslo German encoding on the machine. Build 19608. Could it be you are using an old version of the transformer? Have you tried adding a new one to the worksapce? or tired going through the upgrade transformer wizard?

No they are uptodate and i added new one

Hi @clemensb,

For a workaround, please save your Excel table to CSV, then import the CSV file into the AttributeValueMapper. The CSV reader has an Advanced parameter that lets you control the encoding of the source file, so you can force the correct encoding.

Hi @daveatsafe,

i tried now the csv-reader. Here is the opposite effect i tried various encodings, preview was fine, import was bad. Then i used utf-8, here is a error in the preview, but the import is fine! I will use the csv-workaround. Hopefully with the next version the excel will also work. Thank you!

No but I tried it on also on other PCs in your office. There is the same problem. It might be some setting from our IT which leads to this strange behavior. So i dont think reinstalling will change this.

Does the Excel reader have the same problem when reading? That would be an interesting test.

I just tested it, the Excel reader works normal. This is really strange