EDN Admin
Well-known member
Hello all,
From the Clipboard I am retrieving a SpreadSheetML XML document containing a fragment of an Excel table, and load it into an XMLDocument object, which seems to work OK except for the fact that XPath doesnt work, returning null for existing nodes.
Heres what I have in Watches:
<pre style="font-family:Courier New ss.DocumentElement.ChildNodes[1]: {Element, Name="Worksheet"}
ss.DocumentElement.ChildNodes[1].ChildNodes[0]: {Element, Name="Table"}
ss.DocumentElement.SelectSingleNode("//Worksheet"): null
ss.DocumentElement.SelectSingleNode("//Table"): null
[/code]
Could you please help me?
Anton
View the full article
From the Clipboard I am retrieving a SpreadSheetML XML document containing a fragment of an Excel table, and load it into an XMLDocument object, which seems to work OK except for the fact that XPath doesnt work, returning null for existing nodes.
Heres what I have in Watches:
<pre style="font-family:Courier New ss.DocumentElement.ChildNodes[1]: {Element, Name="Worksheet"}
ss.DocumentElement.ChildNodes[1].ChildNodes[0]: {Element, Name="Table"}
ss.DocumentElement.SelectSingleNode("//Worksheet"): null
ss.DocumentElement.SelectSingleNode("//Table"): null
[/code]
Could you please help me?
Anton
View the full article