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>