RE: Different outputs when i change namespace in an xm

Hi,

> Here is a stripped down version of excel xml. When i use the 
> my test xsl on
> the xml file, i only get the values
> of the 2 data elemens of the cell ( 100 and "test" ). But 
> when i remove
> xmlns="urn:schemas-microsoft-com:office:spreadsheet"
> from the Workbook element in the input xml, i get a 
> completely other output.
> Why is this?

Because in your XSLT stylesheet you're matching elements in null-namespace. Use e.g.

<?xml version="1.0" encoding="iso-8859-1"?>
<xsl:stylesheet
 xmlns:xsl="http://www.w3.org/1999/XSL/Transform" version="1.0"
 xmlns:e="urn:schemas-microsoft-com:office:spreadsheet">

<xsl:output method="xml"
            indent="yes"/>

<xsl:template match="e:Workbook">
  <xsl:copy>
      <xsl:apply-templates select="*"/>
  </xsl:copy>
</xsl:template>

<xsl:template match="*[ancestor::e:Workbook]">
  <xsl:copy>
    <xsl:apply-templates select="*"/>
  </xsl:copy>
</xsl:template>

</xsl:stylesheet>

Santtu

 XSL-List info and archive:  http://www.mulberrytech.com/xsl/xsl-list