7,762
社区成员
发帖
与我相关
我的任务
分享
Select Case pIn01
Case "A01" :
If pIn02 = 0 Then
If pIn03 = 2 Then
pOut01 = "X01"
pOut02 = "Y01"
pOut03 = 0
Else
pOut03 = 1
End If
Else
pOut03 = 2
End If
Case "B01" :
If pIn02 = 1 Then
If pIn03 = 3 Then
pOut01 = "X02"
pOut02 = "Y02"
pOut03 = 0
Else
pOut03 = 1
End If
Else
pOut03 = 2
End If
Case "C01" :
If pIn02 = 0 Then
If pIn03 = 3 Or pIn03 = 4 Then
pOut01 = "X03"
pOut02 = "Y03"
pOut03 = 0
Else
pOut03 = 1
End If
Else
pOut03 = 2
End If
Case "D01" :
If pIn02 = 0 Then
If pIn03 = 2 Then
pOut01 = "X04"
pOut02 = "Y04"
pOut03 = 0
Else
pOut03 = 1
End If
Else
If pIn03 = 4 Then
pOut01 = "X05"
pOut02 = "Y05"
pOut03 = 0
Else
pOut03 = 1
End If
End If
Case "E01" :
If pIn02 = 0 Then
pOut03 = 2
Else
If pIn03 = 4 Then
pOut01 = "X06"
pOut02 = "Y06"
pOut03 = 0
Else
pOut03 = 1
End If
End If
Case "F01" :
If pIn02 = 0 Then
If pIn03 = 3 Then
If pIn04 = "NAME01" Then
pOut01 = "X07"
pOut02 = "Y07"
pOut03 = 0
ELSE
pOut01 = "X08"
pOut02 = "Y08"
pOut03 = 0
END IF
Else
pOut03 = 1
End If
Else
pOut03 = 2
End If
Case Else :
pOut03 = 2
End Select
<?xml version="1.0"?>
<Table>
<Row>
<pIn01>A01</pIn01>
<pIn02></pIn02>
<pIn03></pIn03>
<pOut01></pOut01>
<pOut02></pOut02>
<pOut03>2</pOut03>
</Row>
<Row>
<pIn01>A01</pIn01>
<pIn02>0</pIn02>
<pIn03></pIn03>
<pOut01></pOut01>
<pOut02></pOut02>
<pOut03>1</pOut03>
</Row>
<Row>
<pIn01>A01</pIn01>
<pIn02>0</pIn02>
<pIn03>2</pIn03>
<pOut01>X01</pOut01>
<pOut02>Y01</pOut02>
<pOut03>0</pOut03>
</Row>
<Row>
<pIn01>B01</pIn01>
<pIn02></pIn02>
<pIn03></pIn03>
<pOut01></pOut01>
<pOut02></pOut02>
<pOut03>2</pOut03>
</Row>
<Row>
<pIn01>B01</pIn01>
<pIn02>1</pIn02>
<pIn03></pIn03>
<pOut01></pOut01>
<pOut02></pOut02>
<pOut03>1</pOut03>
</Row>
<Row>
<pIn01>B01</pIn01>
<pIn02>1</pIn02>
<pIn03>3</pIn03>
<pOut01>X02</pOut01>
<pOut02>Y02</pOut02>
<pOut03>0</pOut03>
</Row>
</Table>
Dim pIn01
Dim pIn02
Dim pIn03
Dim pOut01
Dim pOut02
Dim pOut03
Call Main()
Sub Main()
pIn01 = "A01"
pIn02 = 1
pIn03 = 3
Query
MsgBox "pOut01=" & pOut01 & vbCrLf & _
"pOut02=" & pOut02 & vbCrLf & _
"pOut03=" & pOut03
End Sub
Sub Query()
Dim doc
Dim node
Set doc = WScript.CreateObject("MSXML2.DOMDocument")
doc.Load ("x.xml") '<- 自己补齐路径'
Set node = doc.selectSingleNode("/Table/Row[(pIn01=""" & pIn01 & """) and (pIn02=""" & pIn02 & """) and (pIn03=""" & pIn03 & """)]")
If node Is Nothing Then
Set node = doc.selectSingleNode("/Table/Row[(pIn01=""" & pIn01 & """) and (pIn02=""" & pIn02 & """)]")
If node Is Nothing Then
Set node = doc.selectSingleNode("/Table/Row[pIn01=""" & pIn01 & """]")
End If
End If
pOut01 = node.selectSingleNode("pOut01").Text
pOut02 = node.selectSingleNode("pOut02").Text
pOut03 = node.selectSingleNode("pOut03").Text
End Sub
pIn01 pIn02 pIn03 pOut01 pOut02 pOut01
A 0 1 X1 Y1 Z1
B 0 2 X2 Y2 Z2
C 0 3 X3 Y3 Z3
D 1 1 X4 Y4 Z4
E 1 2 X5 Y5 Z5
F 1 3 X6 Y6 Z6
你打开 Excel,将上面数据复制粘贴到一个表中。
然后,另存为“XML 表格(*.xml)“。你访问这个自用工具表格就可以了。