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
________________________________________________________________________