title: Xslt 1.0 XML to excel transformation issue
body: <p>I'm using the .Net framework's XslCompiledTransform class as the XSLT processor (in other words Xslt 1.0).</p>
  
  <p>My requirement is that I want to convert an XML file to an Excel file (xls file) using XSLT 1.0 and .Net [4.0].</p>
  
  <p>For simplicity and since this is just test code, I'm just considering some simple hard-coding on my Xsl file.</p>
  
  <p>Specifically, my two questions are:</p>
  
  <ol>
  <li>I've tried a bunch of things, yet I can't see my Excel sheet's worksheet named to "wAbc" which is what I'm trying to name it. I see the worksheet name as my file name. Additional worksheets are not generated as well. Below is my XSL file</li>
  <li><p>Additionally, since this is test code, I can't see the data outputted on different rows unless I use HTML tags . What I see is: <code>AbcNext line</code> instead of</p>
  
  <p>Abc
  Nextline</p></li>
  </ol>
  
  <p>So what am I doing wrong? Thank you in advance for your time and help.</p>
  
  <p>I set the content type for my file response as</p>
  
  <pre><code>application/vnd.ms-excel
  </code></pre>
  
  <p>Here is my test Xsl file:</p>
  
  <pre><code>&lt;?xml version="1.0"?&gt;
      &lt;xsl:stylesheet version="1.0"
          xmlns="urn:schemas-microsoft-com:office:spreadsheet"
          xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
          xmlns:msxsl="urn:schemas-microsoft-com:xslt"
          xmlns:o="urn:schemas-microsoft-com:office:office"
          xmlns:x="urn:schemas-microsoft-com:office:excel"
          xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet" 
      xmlns:html="http://www.w3.org/TR/REC-html40"&gt;
  
  
        &lt;xsl:template match="/"&gt;
          &lt;xsl:processing-instruction name="mso-application"&gt;progid='Excel.Sheet'&lt;/xsl:processing-instruction&gt;
          &lt;Workbook&gt;
              &lt;Worksheet ss:Name="wAbc"&gt;
                &lt;Table ss:ExpandedColumnCount="2" x:FullColumns="1" x:FullRows="1" ss:DefaultRowHeight="15"&gt;
                  &lt;Column ss:AutoFitWidth="20" ss:AutoWidth="65"&gt;&lt;/Column&gt;
                  &lt;Row&gt;
                    &lt;Cell&gt;
                      &lt;Data ss:Type="String"&gt;Abc&lt;/Data&gt;
                    &lt;/Cell&gt;
                  &lt;/Row&gt;
                  &lt;Row&gt;
                    &lt;Cell&gt;
                      &lt;Data ss:Type="String"&gt;Next line&lt;/Data&gt;
                    &lt;/Cell&gt;
                  &lt;/Row&gt;
                &lt;/Table&gt;
                &lt;WorksheetOptions xmlns="urn:schemas-microsoft-com:office:excel"&gt;
                  &lt;PageSetup&gt;
                    &lt;Header x:Margin="0.3"/&gt;
                    &lt;Footer x:Margin="0.3"/&gt;
                    &lt;PageMargins x:Bottom="0.75" x:Left="0.7" x:Right="0.7" x:Top="0.75"/&gt;
                  &lt;/PageSetup&gt;
                &lt;/WorksheetOptions&gt;
              &lt;/Worksheet&gt;
          &lt;/Workbook&gt;
        &lt;/xsl:template&gt;
      &lt;/xsl:stylesheet&gt;
  </code></pre>