我找到了几个相关的问题,但是它们都没有给我一种使它起作用的方法。
我有一个带有此结构的XML文件:
<?xml version="1.0" encoding="utf-8"?>
<ArrayOfAssessmentItemTimed xmlns:xsi="http://a.b.c/" xmlns:xsd="http://d.e.f" xmlns="http://g.h.i">
<AssessmentItemTimed>
<CustomerId>306</CustomerId>
<AssessmentId>1959060</AssessmentId>
<ExternalReference />
<License>0577HJK</License>
<ChassisNumber>VF1KT1RG646667276</ChassisNumber>
<CostTraditional>2771.16</CostTraditional>
<CostCommercial>2771.16</CostCommercial>
<Kilometers>90957</Kilometers>
<TimeOrdered>2017-02-13T16:31:00.48</TimeOrdered>
<TimeClosed>2017-02-17T17:09:43.14</TimeClosed>
</AssessmentItemTimed>
<AssessmentItemTimed>
<CustomerId>306</CustomerId>
<AssessmentId>1959061</AssessmentId>
<ExternalReference />
<License>0918HHM</License>
<ChassisNumber>VF1KT1RG646272649</ChassisNumber>
<CostTraditional>3293.33</CostTraditional>
<CostCommercial>3293.33</CostCommercial>
<Kilometers>158142</Kilometers>
<TimeOrdered>2017-02-13T16:31:01.73</TimeOrdered>
<TimeClosed>2017-02-16T21:05:38.98</TimeClosed>
</AssessmentItemTimed>
</ArrayOfAssessmentItemTimed>
我只有从标签中删除名称空间时才能获取所需的数据。这是我当前的代码:
Dim xmlnode As XmlDocument
Dim nodeList As XmlNodeList
Dim node As XmlNode
Dim nsmgr As XmlNamespaceManager
Try
xmlnode = New XmlDocument()
xmlnode.Load("file.xml")
nsmgr = New XmlNamespaceManager(xmlnode .NameTable)
nodeList = xmlnode.DocumentElement.SelectNodes("/sd:ArrayOfAssessmentItemTimed/sd:AssessmentItemTimed", nsmgr)
For Each xmlnode In nodeList
Dim plateNumber = xmlnode.SelectSingleNode("sd:License", nsmgr).InnerText
Dim chassisNumber = xmlnode.SelectSingleNode("sd:ChassisNumber", nsmgr).InnerText
Dim Kilometers = mlnode.SelectSingleNode("sd:Kilometers", nsmgr).InnerText
'test if works
MsgBox("License: " & plateNumber & vbCrLf _
& "Chassis: " & chassisNumber & vbCrLf _
& "Kms: " & Kilometers & vbCrLf & vbCrLf
)
Next
Catch errorVariable As Exception
'Error trapping
MsgBox(errorVariable.ToString())
End Try
哪种可能是排除XMLNS值的正确方法?我真的不了解XmlnamespaceManager,所以我无法获得积极的结果。
感谢您的所有建议。
您需要使用XmlNamespaceManager
注册前缀'SD',然后才能在XPath查询中使用它。确保将前缀映射到默认名称空间http://g.h.i
:
....
nsmgr = New XmlNamespaceManager(New XmlNameTable())
nsmgr.AddNamespace("sd", "http://g.h.i");
nodeList = xmlnode.DocumentElement.SelectNodes("/sd:ArrayOfAssessmentItemTimed/sd:AssessmentItemTimed", nsmgr)
....
x path总是在没有前缀的情况下将元素视为具有空名称空间的元素,它没有默认名称空间的概念(只有XML具有),这就是为什么您需要在此处编写前缀'SD'。
您可以检查如何:声明并使用XML名称空间前缀以进行更简单的替代方案。
Imports <xmlns="http://g.h.i">
和样本使用:
'' Dim xDoc = System.Xml.Linq.XDocument.Load("file.xml")
Dim xDoc = <?xml version="1.0" encoding="utf-8"?>
<ArrayOfAssessmentItemTimed xmlns:xsi="http://a.b.c/"
xmlns:xsd="http://d.e.f" xmlns="http://g.h.i">
<AssessmentItemTimed>
<License>0577HJK</License>
<ChassisNumber>VF1KT1RG646667276</ChassisNumber>
<Kilometers>90957</Kilometers>
</AssessmentItemTimed>
<AssessmentItemTimed>
<License>0918HHM</License>
<ChassisNumber>VF1KT1RG646272649</ChassisNumber>
<Kilometers>158142</Kilometers>
</AssessmentItemTimed>
</ArrayOfAssessmentItemTimed>
For Each x In xDoc.<ArrayOfAssessmentItemTimed>.<AssessmentItemTimed>
MsgBox("License: " & vbTab & x.<License>.Value & vbLf &
"Chassis: " & vbTab & x.<ChassisNumber>.Value & vbLf &
"Kms: " & vbTab & x.<Kilometers>.Value & vbLf)
Next