Subject: Re: 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
________________________________________________________________________
|