Problem with reading XML

[prasanta]

Hello,
I have a xml file. when i am trying to load through XPathDocument and
try to get XPathNodeIterat or its not working . my xml is loking like

<?xml version="1.0" ?>
<?mso-application progid="Excel.S heet"?>
<Workbook xmlns="urn:sche mas-microsoft-com:office:spre adsheet"
xmlns:o="urn:sc hemas-microsoft-com:office:offi ce"
xmlns:x="urn:sc hemas-microsoft-com:office:exce l"
xmlns:ss="urn:s chemas-microsoft-com:office:spre adsheet"
xmlns:html="htt p://www.w3.org/TR/REC-html40">
<Styles>
<Style ss:ID="Default" ss:Name="Normal ">
<Alignment ss:Vertical="Bo ttom" />
<Borders />
<Font />
<Interior />
<NumberFormat />
<Protection />
</Style>
<Style ss:ID="s22">
<Font x:Family="Swiss " ss:Bold="1" />
</Style>
</Styles>
</Workbook>

Code:
XPathDocument xpDoc = new XPathDocument(p ath);
XPathNavigator xpNav = xpDoc.CreateNav igator();
XPathNodeIterat or xpite =
xpNav.Select("/Workbook/Styles/Style/@ID");
Console.WriteLi ne("No of item::"+xpite.C ount.ToString() );
while(xpite.Mov eNext())
{
Console.WriteLi ne(xpite.Curren t.Value);
}

But with this code i am not getting any result and its thrown exception
as

Xpath:System.Xm l.XmlException: This is an unexpected token. The
expected token i
s 'NAME'. Line 14, position 15.
at System.Xml.XmlT extReader.SetAt tributeValues()
at System.Xml.XmlT extReader.Parse Element()
at System.Xml.XmlT extReader.Read( )
at System.Xml.XmlV alidatingReader .ReadNoCollectT extToken()
at System.Xml.XmlV alidatingReader .Read()
at System.Xml.XPat h.XPathDocument .ReadChildNodes (XPathContainer
parent, Strin
g parentBaseUri, XmlReader reader, PositionInfo positionInfo)
at System.Xml.XPat h.XPathDocument .ReadChildNodes (XPathContainer
parent, Strin
g parentBaseUri, XmlReader reader, PositionInfo positionInfo)
at System.Xml.XPat h.XPathDocument .ReadChildNodes (XPathContainer
parent, Strin
g parentBaseUri, XmlReader reader, PositionInfo positionInfo)
at System.Xml.XPat h.XPathDocument .ReadChildNodes (XPathContainer
parent, Strin
g parentBaseUri, XmlReader reader, PositionInfo positionInfo)
at System.Xml.XPat h.XPathDocument .Load(XmlReader reader)
at System.Xml.XPat h.XPathDocument .Init(XmlReader reader)
at System.Xml.XPat h.XPathDocument ..ctor(String uri)
at test.Class1.cel lDiff(String path) in c:\test\class1. cs:line 70

But if i modify the xml look like

<Workbook>
<Styles>
<Style ID="Default" Name="Normal">
<Alignment Vertical="Botto m" />
<Borders />
<Font />
<Interior />
<NumberFormat />
<Protection />
</Style>
<Style ID="s22">
<Font Family="Swiss" Bold="1" />
</Style>
</Styles>
</Workbook>

and getting result with same code. How can i read above XML without
doing any modification.
Thanks,
Prasanta

[dickster]

Not 100% sure what you are hoping to see and cannot regenerate that
error.

However is the xpath expression your looking:

/Workbook/Styles/Style/@ss:ID

Dickster

[prasanta]

Hello,
this is my full XML content..
<?xml version="1.0" ?>
<?mso-application progid="Excel.S heet"?>
<Workbook xmlns="urn:sche mas-microsoft-com:office:spre adsheet"
xmlns:o="urn:sc hemas-microsoft-com:office:offi ce"
xmlns:x="urn:sc hemas-microsoft-com:office:exce l"
xmlns:ss="urn:s chemas-microsoft-com:office:spre adsheet"
xmlns:html="htt p://www.w3.org/TR/REC-html40">
<Styles>
<Style ss:ID="Default" ss:Name="Normal ">
<Alignment ss:Vertical="Bo ttom" />
<Borders />
<Font />
<Interior />
<NumberFormat />
<Protection />
</Style>
<Style ss:ID="s22">
<Font x:Family="Swiss " ss:Bold="1" />
</Style>
</Styles>
<Worksheet ss:Name="Sheet1 ">
<Names>
<NamedRange ss:Name="Reify_ 09021612_5a3c_4 188_8fd2_bcc24b efeac6"
ss:RefersTo="=S heet1!R1C1:R4C3 " />
<NamedRange ss:Name="Reify_ 09021612_5a3c_4 188_8fd2_bcc24b efeac6.C0"
ss:RefersTo="=S heet1!R1C1:R4C1 " />
<NamedRange ss:Name="Reify_ 09021612_5a3c_4 188_8fd2_bcc24b efeac6.C1"
ss:RefersTo="=S heet1!R1C2:R4C2 " />
<NamedRange ss:Name="Reify_ 09021612_5a3c_4 188_8fd2_bcc24b efeac6.C2"
ss:RefersTo="=S heet1!R1C3:R4C3 " />
<NamedRange ss:Name="Reify_ 09021612_5a3c_4 188_8fd2_bcc24b efeac6.R0"
ss:RefersTo="=S heet1!R1C1:R1C3 " />
<NamedRange ss:Name="Reify_ 09021612_5a3c_4 188_8fd2_bcc24b efeac6.R1"
ss:RefersTo="=S heet1!R2C1:R2C3 " />
<NamedRange ss:Name="Reify_ 09021612_5a3c_4 188_8fd2_bcc24b efeac6.R2"
ss:RefersTo="=S heet1!R3C1:R3C3 " />
<NamedRange ss:Name="Reify_ 09021612_5a3c_4 188_8fd2_bcc24b efeac6.R3"
ss:RefersTo="=S heet1!R4C1:R4C3 " />
<NamedRange ss:Name="Reify_ 4fd3e104_67ff_4 ac7_95a6_4a34dd 3251e1"
ss:RefersTo="=S heet1!R2C2:R3C3 " />
<NamedRange ss:Name="Reify_ 4fd3e104_67ff_4 ac7_95a6_4a34dd 3251e1.C0"
ss:RefersTo="=S heet1!R2C2:R3C2 " />
<NamedRange ss:Name="Reify_ 4fd3e104_67ff_4 ac7_95a6_4a34dd 3251e1.C1"
ss:RefersTo="=S heet1!R2C3:R3C3 " />
<NamedRange ss:Name="Reify_ 4fd3e104_67ff_4 ac7_95a6_4a34dd 3251e1.R0"
ss:RefersTo="=S heet1!R2C2:R2C3 " />
<NamedRange ss:Name="Reify_ 4fd3e104_67ff_4 ac7_95a6_4a34dd 3251e1.R1"
ss:RefersTo="=S heet1!R3C2:R3C3 " />
</Names>
<Table ss:ExpandedColu mnCount="3" ss:ExpandedRowC ount="4">
<Row>
<Cell ss:StyleID="s22 ">
<Data ss:Type="String ">v</Data>
<NamedCell ss:Name="Reify_ 09021612_5a3c_4 188_8fd2_bcc24b efeac6.R0"
/>
<NamedCell ss:Name="Reify_ 09021612_5a3c_4 188_8fd2_bcc24b efeac6.C0"
/>
<NamedCell ss:Name="Reify_ 09021612_5a3c_4 188_8fd2_bcc24b efeac6" />
</Cell>
</Row>
<Row>
<Cell ss:Index="2">
<Data ss:Type="String ">a</Data>
<NamedCell ss:Name="Reify_ 09021612_5a3c_4 188_8fd2_bcc24b efeac6.R1"
/>
<NamedCell ss:Name="Reify_ 4fd3e104_67ff_4 ac7_95a6_4a34dd 3251e1.R0"
/>
<NamedCell ss:Name="Reify_ 4fd3e104_67ff_4 ac7_95a6_4a34dd 3251e1.C0"
/>
<NamedCell ss:Name="Reify_ 4fd3e104_67ff_4 ac7_95a6_4a34dd 3251e1" />
<NamedCell ss:Name="Reify_ 09021612_5a3c_4 188_8fd2_bcc24b efeac6.C1"
/>
<NamedCell ss:Name="Reify_ 09021612_5a3c_4 188_8fd2_bcc24b efeac6" />
</Cell>
</Row>
<Row>
<Cell ss:Index="3">
<Data ss:Type="String ">a</Data>
<NamedCell ss:Name="Reify_ 4fd3e104_67ff_4 ac7_95a6_4a34dd 3251e1" />
<NamedCell ss:Name="Reify_ 4fd3e104_67ff_4 ac7_95a6_4a34dd 3251e1.C1"
/>
<NamedCell ss:Name="Reify_ 09021612_5a3c_4 188_8fd2_bcc24b efeac6.R2"
/>
<NamedCell ss:Name="Reify_ 4fd3e104_67ff_4 ac7_95a6_4a34dd 3251e1.R1"
/>
<NamedCell ss:Name="Reify_ 09021612_5a3c_4 188_8fd2_bcc24b efeac6" />
<NamedCell ss:Name="Reify_ 09021612_5a3c_4 188_8fd2_bcc24b efeac6.C2"
/>
</Cell>
</Row>
<Row>
<Cell ss:Index="3">
<Data ss:Type="String ">v</Data>
<NamedCell ss:Name="Reify_ 09021612_5a3c_4 188_8fd2_bcc24b efeac6" />
<NamedCell ss:Name="Reify_ 09021612_5a3c_4 188_8fd2_bcc24b efeac6.C2"
/>
<NamedCell ss:Name="Reify_ 09021612_5a3c_4 188_8fd2_bcc24b efeac6.R3"
/>
</Cell>
</Row>
</Table>
</Worksheet>
</Workbook>

from that xml i want to iterate all the <Cell> node.
My code is like

string xPath = "/Workbook/Worksheet/Table/Row/Cell";
XPathDocument xpDoc = new XPathDocument(p ath);
XPathNavigator xpNav = xpDoc.CreateNav igator();
XPathNodeIterat or xpite = xpNav.Select(xP ath);
Console.WriteLi ne("No of item::"+xpite.C ount.ToString() );

When i run this code its showing No of item::0
I wrote XPath = "/Workbook/Worksheet/Table/Row/Cell" otherway "//Cell"
Both are giving count 0.

Thanks,
Prasanta

[dickster]

I reckon its to do with your default names space

i.e. xmlns="urn:sche mas-microsoft-com:office:spre adsheet"

check out
http://msdn.microsoft.com/library/de...edPrefixes.asp

[dickster]

Prasanta

I found this a hard bit to understand in that article

"The XmlNamespaceMan ager allows adding default namespaces by using an
empty string as the prefix. However, XPath treats the empty prefix as
the null namespace. In other words, only prefixes mapped to namespaces
can be used in XPath queries. If you want to use the default namespace
from an XML document in the XPath expression, then you need to define a
prefix for it."

But I think for your code it translates to:

string xPath =
"/dpx:Workbook/dpx:Worksheet/dpx:Table/dpx:Row/dpx:Cell";
XPathDocument xpDoc = new XPathDocument(< <path>>);
XPathNavigator xpNav = xpDoc.CreateNav igator();

XmlNamespaceMan ager context = new
XmlNamespaceMan ager(xpNav.Name Table);

// Call dpx - TheDefaultPrefi x
context.AddName space("dpx","ur n:schemas-microsoft-com:office:spre adsheet");
context.AddName space("ss","urn :schemas-microsoft-com:office:spre adsheet");
context.AddName space("o","urn: schemas-microsoft-com:office:offi ce");
context.AddName space("x","urn: schemas-microsoft-com:office:exce l");

XPathExpression Expr = xpNav.Compile(x Path);
Expr.SetContext (context);

XPathNodeIterat or xpite = xpNav.Select(Ex pr);
Console.WriteLi ne("No of item::"+xpite.C ount.ToString() );

while(xpite.Mov eNext())
{
Console.WriteLi ne(xpite.Curren t.Value);
}
Console.Read();

[prasanta]

Hi Dickster ,
Thanks for replaying. Now its working.

Thanks,
Prasanta