unwanted empty xmlns string in the output.

[CI]

I have the following XML file:

<?xml version="1.0" encoding="UTF-8" standalone="yes "?>
<workbook xmlns="http://schemas.openxml formats.org/spreadsheetml/2006/
main" xmlns:r="http://schemas.openxml formats.org/officeDocument/2006/
relationships">
<fileVersion appName="xl" lastEdited="4" lowestEdited="4 "
rupBuild="4505"/>
<workbookPr defaultThemeVer sion="124226"/>
<bookViews>
<workbookView xWindow="120" yWindow="45" windowWidth="18 975"
windowHeight="1 1955" activeTab="2"/>
</bookViews>
<sheets>
<sheet name="chicago" sheetId="1" r:id="rId1"/>
<sheet name="boston" sheetId="2" state="hidden" r:id="rId2"/>
<sheet name="austin" sheetId="3" r:id="rId3"/>
</sheets>
<calcPr calcId="124519"/>
</workbook>
I created a stylesheet to get rid off the 'state' attribute of a
<sheetelment(s) .
<?xml version="1.0" encoding="utf-8"?>
<xsl:styleshe et version="1.0" xmlns:xsl="http ://www.w3.org/1999/XSL/
Transform"
xmlns:y="http://schemas.openxml formats.org/spreadsheetml/2006/
main"
xmlns:r="http://schemas.openxml formats.org/officeDocument/2006/
relationships"
exclude-result-prefixes="y">

<xsl:template match="@*|node( )">
<xsl:copy>
<xsl:apply-templates select="@*|node ()"/>
</xsl:copy>
</xsl:template>

<xsl:template match="y:sheet" >
<sheet name="{@name}" sheetId="{@shee tId}" r:id="{@r:id}">
<xsl:apply-templates/>
</sheet>
</xsl:template>

</xsl:stylesheet>
And here is the result I get:

<?xml version="1.0"?>
<workbook xmlns="http://schemas.openxml formats.org/spreadsheetml/2006/
main" xmlns:r="http://schemas.openxml formats.org/officeDocument/2006/
relationships">
<fileVersion appName="xl" lastEdited="4" lowestEdited="4 "
rupBuild="4505"/>
<workbookPr defaultThemeVer sion="124226"/>
<bookViews>
<workbookView xWindow="120" yWindow="45" windowWidth="18 975"
windowHeight="1 1955" activeTab="2"/>
</bookViews>
<sheets>
<sheet name="chicago" sheetId="1" r:id="rId1" xmlns=""/>
<sheet name="boston" sheetId="2" r:id="rId2" xmlns=""/>
<sheet name="austin" sheetId="3" r:id="rId3" xmlns=""/>
</sheets>
<calcPr calcId="124519"/>
</workbook>

The tool used is MSXML.
I would greatly appreciate if anyone can suggest how to avoid having
xmlns="" in my output tree.

Regards,

Michael

[Martin Honnen]

CI wrote:

I created a stylesheet to get rid off the 'state' attribute of a
<sheetelment(s) .
<?xml version="1.0" encoding="utf-8"?>
<xsl:styleshe et version="1.0" xmlns:xsl="http ://www.w3.org/1999/XSL/
Transform"
xmlns:y="http://schemas.openxml formats.org/spreadsheetml/2006/
main"
xmlns:r="http://schemas.openxml formats.org/officeDocument/2006/
relationships"
exclude-result-prefixes="y">

<xsl:template match="@*|node( )">
<xsl:copy>
<xsl:apply-templates select="@*|node ()"/>
</xsl:copy>
</xsl:template>

<xsl:template match="y:sheet" >
<sheet name="{@name}" sheetId="{@shee tId}" r:id="{@r:id}">
<xsl:apply-templates/>
</sheet>
</xsl:template>

It should suffice to use
<xsl:template match="@state"/>
in addition to your first template. That would delete all state
attributes on all elements. If you want to have it for the sheet
elements only then use e.g.
<xsl:template match="y:sheet/@state"/>

--

Martin Honnen
http://JavaScript.FAQTs.com/

[CI]

Thanks Martin. It worked.

Michael