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.