[XSL-LIST Mailing List Archive Home]
[By Thread]
[By Date]
RE: [xsl] please help. newbie needs help!!
Subject: RE: [xsl] please help. newbie needs help!! From: "Michael Kay" <mhk@xxxxxxxxx> Date: Tue, 11 May 2004 09:02:41 +0100 |
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: [xsl] 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>
Current Thread |
---|
|
<- Previous | Index | Next -> |
---|---|---|
RE: [xsl] please help. newbie needs, M. David Peterson | Thread | Re: [xsl] please help. newbie needs, Jeni Tennison |
Re: [xsl] problem SOLVED: recursive, poppe chris | Date | Re: [xsl] order-by in WD-xsl?, David Carlisle |
Month |