Re: [xsl] Problem while Xpath-ing an excel XML exported file

Subject: Re: [xsl] Problem while Xpath-ing an excel XML exported file
From: David Carlisle <davidc@xxxxxxxxx>
Date: Thu, 17 Mar 2005 16:09:14 GMT
namespace FAQ number 1:

<Workbook xmlns="urn:schemas-microsoft-com:office:spreadsheet" ...
   ...
  <Worksheet

so that is Workbook and Worksheet in  namespace
urn:schemas-microsoft-com:office:spreadsheet

and this

<xsl:for-each select="Workbook/Worksheet

selects so that is Workbook and Worksheet in  no-namespace

so selects nothing in this case.

You want

xmlns:x="urn:schemas-microsoft-com:office:spreadsheet" on your
xsl:stylseheet then



<xsl:for-each select="x:Workbook/x:Worksheet

etc so that you select elements from this namespace.

David


________________________________________________________________________
This e-mail has been scanned for all viruses by Star. The
service is powered by MessageLabs. For more information on a proactive
anti-virus service working around the clock, around the globe, visit:
http://www.star.net.uk
________________________________________________________________________

Current Thread