RE: please help. newbie needs help!!

The simplest expression that will return "THE WATERSHED 
GROUP, LLC" is "THE WATERSHED GROUP, LLC".

I'm not being facetious. Writing an expression to find a particular string
is trivial if the document is immutable. It only becomes an interesting
exercise if the expression still has to work when the document changes, and
to write the XPath expression correctly, you need to know how much the
document is allowed to change, and what your criteria are for the query.

Are you trying to find the contents of the first cell in the second row? Or
are you trying to find the contents of the first cell whose value ends in
"LLC"? Or the cell that is closest to being half-way down the document?

Michael Kay

> -----Original Message-----
> From: Jeremy Allen [mailto:jallen@xxxxxxxxxxxxxx] 
> Sent: 11 May 2004 03:51
> To: xsl-list@xxxxxxxxxxxxxxxxxxxxxx
> Subject:  please help. newbie needs help!!
> 
> 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"? Any
> help appreciated!!!
> 
> EXALMPLE:
> <?xml version="1.0"?>
> <Workbook
>   xmlns="urn:schemas-microsoft-com:office:spreadsheet"
>   xmlns:o="urn:schemas-microsoft-com:office:office"
>   xmlns:x="urn:schemas-microsoft-com:office:excel"
>   xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet"
>   xmlns:c="urn:schemas-microsoft-com:office:component:spreadsheet"
>   xmlns:html="http://www.w3.org/TR/REC-html40">
>   <DocumentProperties
>     xmlns="urn:schemas-microsoft-com:office:office">
>     <Author>PC Entry</Author>
>     <LastAuthor>PC Entry</LastAuthor>
>     <Created>2004-05-03T09:02:51Z</Created>
>   </DocumentProperties>
>   <OfficeDocumentSettings />
>   <ExcelWorkbook
>     xmlns="urn:schemas-microsoft-com:office:excel">
>     <WindowHeight>7815</WindowHeight>
>     <WindowWidth>7500</WindowWidth>
>     <WindowTopX>360</WindowTopX>
>     <WindowTopY>45</WindowTopY>
>     <ProtectStructure>False</ProtectStructure>
>     <ProtectWindows>False</ProtectWindows>
>   </ExcelWorkbook>
>   <Styles>
>     <Style ss:ID="Default" ss:Name="Normal">
>       <Alignment ss:Vertical="Bottom" />
>     </Style>
>     <Style ss:ID="s21">
>       <NumberFormat ss:Format="Short Date" />
>     </Style>
>     <Style ss:ID="s22">
>       <NumberFormat ss:Format="Fixed" />
>     </Style>
>   </Styles>  <Worksheet ss:Name="Sheet1">
>     <Table>
>       <Column ss:Index="1" ss:Width="315"/>
>       <Column ss:Index="2" ss:Width="153"/>
>       <Column ss:Index="3" ss:Width="297"/>
>       <Column ss:Index="4" ss:Width="126"/>
>       <Column ss:Index="5" ss:Width="126"/>
>       <Column ss:Index="6" ss:Width="72"/>
>       <Column ss:Index="7" ss:Width="90"/>
>       <Column ss:Index="8" ss:Width="108"/>
>       <Row ss:Index="1">
>         <Cell ss:Index="1" >
>           <Data ss:Type="String">111-55555</Data>
>         </Cell>
>       </Row>
>       <Row ss:Index="2">
>         <Cell ss:Index="1" >
>           <Data ss:Type="String">THE WATERSHED GROUP, LLC</Data>
>         </Cell>
>       </Row>
>       <Row ss:Index="3">
>         <Cell ss:Index="1" >
>           <Data ss:Type="String">GUS'S WATERSHED</Data>
>         </Cell>
>       </Row>