Subject:XSLT namespace output Author:Justin Kohlhepp Date:17 Apr 2007 10:47 AM
I have an XSLT which copies an Excel SpreadsheetML doc and modifies it. Instead of the namespace declarations rolling up to the outermost node that it can, I am getting them on every node. I reduced the XSLT to find the problem. I have this:
<xsl:stylesheet
version="1.0"
xmlns="urn:schemas-microsoft-com:office:spreadsheet"
xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet"
xmlns:o="urn:schemas-microsoft-com:office:office"
xmlns:x="urn:schemas-microsoft-com:office:excel"
xmlns:html="http://www.w3.org/TR/REC-html40">
<xsl:output method="xml" omit-xml-declaration="no" indent="no"/>
<xsl:template match="node()|@*">
<xsl:copy>
<xsl:apply-templates select="@*|node()"/>
</xsl:copy>
</xsl:template>
</xsl:stylesheet>
With that, I get output that looks like this:
<Workbook xmlns="urn:schemas-microsoft-com:office:spreadsheet" ...>
<!-- Snip -->
<ExcelWorkbook xmlns="urn:schemas-microsoft-com:office:excel">
<WindowHeight xmlns="urn:schemas-microsoft-com:office:spreadsheet">11640</WindowHeight>
<WindowWidth xmlns="urn:schemas-microsoft-com:office:spreadsheet">15195</WindowWidth>
<WindowTopX xmlns="urn:schemas-microsoft-com:office:spreadsheet">360</WindowTopX>
<WindowTopY xmlns="urn:schemas-microsoft-com:office:spreadsheet">120</WindowTopY>
<ProtectStructure xmlns="urn:schemas-microsoft-com:office:spreadsheet">False</ProtectStructure>
<ProtectWindows xmlns="urn:schemas-microsoft-com:office:spreadsheet">False</ProtectWindows>
</ExcelWorkbook>
<!-- Snip -->
</Workbook>
If I remove the xmlns="urn:schemas-microsoft-com:office:spreadsheet" from the XSLT then my output looks correct, like this:
<Workbook xmlns="urn:schemas-microsoft-com:office:spreadsheet" ...>
<!-- Snip -->
<ExcelWorkbook xmlns="urn:schemas-microsoft-com:office:excel">
<WindowHeight>11640</WindowHeight>
<WindowWidth>15195</WindowWidth>
<WindowTopX>360</WindowTopX>
<WindowTopY>120</WindowTopY>
<ProtectStructure>False</ProtectStructure>
<ProtectWindows>False</ProtectWindows>
</ExcelWorkbook>
<!-- Snip -->
</Workbook>
Why does having that default NS declaration in the XSLT cause the output to not roll up the NS? In general, how does the XSLT processor decide where to put NS declarations? Is there any documentation on this?