OK - Problem while Xpath-ing an excel XML export

Thank your very much... David.I was on my way to knock my head on the wall and
smoke one cigarette after the other!!!

It works now!

Regards

Lawrence Michel


-----Urspr|ngliche Nachricht-----
Von: David Carlisle [mailto:davidc@xxxxxxxxx]
Gesendet: Donnerstag, 17. Mdrz 2005 17:09
An: xsl-list@xxxxxxxxxxxxxxxxxxxxxx
Betreff: Re:  Problem while Xpath-ing an excel XML exported file



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
________________________________________________________________________