Re: please help. newbie needs help!!

Hi Jeremy,

> I need an xpath expression for getting data from this xml, for
> example what expression would I use to get the string "THE WATERSHED
> GROUP, LLC"?

M.David Peterson has given you some good ideas about how to get this
string, but he missed one important feature of the XML that you're
working with, namely that it's using a default namespace. This is
something that trips people up all the time, so perhaps it's something
you're having problems with too...

Your data uses default namespaces, with different defaults in
different areas. The default that's declared at the top level of the
XML, on the <Workbook> element, is declared with:

  xmlns="urn:schemas-microsoft-com:office:spreadsheet"

This namespace declaration is in scope for most of the elements, with
the exceptions of the <DocumentProperties> element and its descendants
(which have a default namespace of
urn:schemas-microsoft-com:office:office) and the <ExcelWorkbook>
element and its descendants (which have a default namespace of
urn:schemas-microsoft-com:office:excel). So most of the elements in
your XML document are in the namespace
urn:schemas-microsoft-com:office:spreadsheet.

To refer to elements in a namespace from within an XSLT stylesheet,
you need to do two things:

  - declare the namespace, associating it with a prefix, at the very
    top of the stylesheet

  - use the prefix that you've associated with the namespace whenever
    you refer to an element in that namespace

So, to get to the <Data> element that you're interested in, you need
to declare the urn:schemas-microsoft-com:office:spreadsheet namespace,
like so:

<xsl:stylesheet version="1.0"
                xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
                xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet">
...
</xsl:stylesheet>

And the names of the elements in the path to the relevant <Data>
element need to be prefixed as follows:

  /ss:Workbook
    /ss:Worksheet
      /ss:Table
        /ss:Row[@ss:Index = '2']
          /ss:Cell
            /ss:Data

I've arranged this path on several lines so that you can see how its
structure matches the structure of your document -- you can get rid of
the whitespace if you want.

Note also that there are many ways of selecting the <Row> element that
you're after: the one above chooses the <Row> element whose ss:Index
attribute has the value '2', but you could just use a positional
predicate (ss:Row[2]) to choose the second row in the table.

If you *don't* use a prefix on the element names, then the XSLT
processor will think that you're trying to select elements in no
namespace (no matter what the default namespace in the stylesheet is).
Since there aren't any such in your document, it won't find any, and
you'll get nothing out.

Cheers,

Jeni

---
Jeni Tennison
http://www.jenitennison.com/