title: XML -> XSLT using encoding UTF-8 doesn't work with Microsoft Excel - why?
body: <p>i have a problem with Microsoft Excel and my generated "Textfile - csv" / "Textfile - tab".
  <br><br>
  All application see the UTF-8 encoding and works with German umlauts (äöüßÄÖÜ).<br>
  Notepad++ (Windows 7) opens the file and shows all correct<br>
  Editor (Windows 7) opens the file and shows all correct<br>
  Only the ..... Excel opens the file (if you use it without import option dialog) with the wrong encoding and destroy all German umlauts.<br><br>
  I didn't find a option in the excel preferences to avoid this problem - maybe I'm blind or maybe Microsoft doesn't do a good job on excel.</p>
  
  <p>Is there a way in XSLT to change anything, that excel will do the job correct (without the import option dialog - I know, this works, if you give them the encoding in this dialog)</p>
  
  <p>Right is in the example "München" but excel gives me a wrong result. I can't post the excel result - gives an error in the input field.</p>
  
  <p>I only work in XSLT 1.0</p>
  
  <pre><code>&lt;?xml version="1.0" encoding="UTF-8"?&gt;
  &lt;root&gt;
      &lt;table name="test"&gt;
          &lt;row&gt;
              &lt;field attr3="name"&gt;München&lt;/field&gt;
          &lt;/row&gt;
      &lt;/table&gt;
  &lt;/root&gt;
  
  &lt;?xml version="1.0" encoding="UTF-8"?&gt;
  &lt;xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
  xmlns:xs="http://www.w3.org/2001/XMLSchema" exclude-result-prefixes="xs" version="1.0"&gt;
      &lt;xsl:output method="text" version="1.0" encoding="UTF-8" indent="no"/&gt;
      &lt;xsl:template match="/"&gt;
           &lt;xsl:value-of select="root/table[@name = 'test']/row/field[@attr3 = 'name']"/&gt;
      &lt;/xsl:template&gt;
  &lt;/xsl:stylesheet&gt;
  </code></pre>
  
  <p>The result is saved as .txt in the file system.
  I tried also formats like .csv and .tab - all doesn't work with excel -> but works always in notepad++/editor/....
  Only the "import dialog" in excel gives the characters in the right form - but the users want to double click the file.</p>