MathCAD 13 Document and XMLDocument.Loadxml

[fawkes]

I'm trying to load a MathCAD 13 document into an xmldocument in Visual Studio 2005

        Dim xmlDoc As New Xml.XmlDocument

        'Load the xml document
        xmlDoc.LoadXml("test1.xmcd")

But I get the follwing error message:

Data at the root level is invalid. Line 1, position 1.

The first lines of the xml document are:

<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<?validation-md5-digest a38d3955c9cd5d0521007998f5a2d587?>
<worksheet version="2.0.2" xmlns="[URL unfurl="true"]http://schemas.mathsoft.com/worksheet20"[/URL] xmlns:xsi="[URL unfurl="true"]http://www.w3.org/2001/XMLSchema-instance"[/URL] xmlns:ws="[URL unfurl="true"]http://schemas.mathsoft.com/worksheet20"[/URL] xmlns:ml="[URL unfurl="true"]http://schemas.mathsoft.com/math20"[/URL] xmlns:u="[URL unfurl="true"]http://schemas.mathsoft.com/units10"[/URL] xmlns:p="[URL unfurl="true"]http://schemas.mathsoft.com/provenance10">[/URL]

When I just use

xmlDoc.Load("test1.xmcd")

I struggle to use

xmldoc.SelectNodes("worksheet")

I don't know if it's related but I seem to think so.

Any ideas?

 

[fawkes]

OK,

I know where I've made one mistake, I should have used

xmlDoc.Load("test1.xmcd")

and not

xmlDoc.Loadxml("test1.xmcd")

The LoadXML method is looking for xml text.

I still need help on the select nodes method though

 

[fawkes]

I have it, it's to do with namespaces

Dim nsmgr As Xml.XmlNamespaceManager = New Xml.XmlNamespaceManager(xmlDoc.NameTable)
        nsmgr.AddNamespace("ws", "[URL unfurl="true"]http://schemas.mathsoft.com/worksheet20")[/URL]
        nsmgr.AddNamespace("", "[URL unfurl="true"]http://schemas.mathsoft.com/worksheet20")[/URL]
        nsmgr.AddNamespace("ml", "[URL unfurl="true"]http://schemas.mathsoft.com/math20")[/URL]
        nsmgr.AddNamespace("u", "[URL unfurl="true"]http://schemas.mathsoft.com/units10")[/URL]
        nsmgr.AddNamespace("p", "[URL unfurl="true"]http://schemas.mathsoft.com/provenance10")[/URL]

        Dim wkNode As Xml.XmlNode
        For Each wkNode In xmlDoc.SelectNodes("ws:worksheet", nsmgr)
          '... Code here ...
        Next