Skip to main content
Solved

Excel to XML causing bad encoding (UTF-8)

  • January 17, 2019
  • 2 replies
  • 137 views

I'm trying to create a workspace to create a XML file from an excel-report (Sample) and an excelfile containg some other information (Blad1). However I'm running in to issues with the encoding of the created file. It seems like textwriter is not able to output UTF-8 encoded characters (input contains Swedish characters like åäö).

 

Trying to understand where in the process this gets wierdly formatted but loggers seem to show the right characters.

 

When I exchange these characters manually in the output XML file the validationservice I'm using is working.

 

Anyone who can point out how to fix this? Kind regards.

 

Best answer by lenaatsafe

Hi @flyell

could you please check what the encoding of the values leaving XMLTemplater is and whether the values look right? Also: is Text File Writer Character Encoding parameter set to UTF-8?

View original
Did this help you find an answer to your question?

2 replies

Forum|alt.badge.img
  • Best Answer
  • January 17, 2019

Hi @flyell

could you please check what the encoding of the values leaving XMLTemplater is and whether the values look right? Also: is Text File Writer Character Encoding parameter set to UTF-8?


  • Author
  • January 18, 2019
lenaatsafe wrote:

Hi @flyell

could you please check what the encoding of the values leaving XMLTemplater is and whether the values look right? Also: is Text File Writer Character Encoding parameter set to UTF-8?

It was the Text File Writer Character Encoding that needed to be changed. Thanks for the answer!


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings