Excel VBA 解析 JSON
Sub bluejson() 'ok
Dim aa
Set x = CreateObject("ScriptControl"): x.Language = "JScript"
aa = "{""myname"":""Michael"",""myaddress"":{""city"":""Beijing"",""street"":"" Chaoyang Road "",""postcode"":100025}}"
Set y = x.eval("eval(" & aa & ")")
MsgBox y.myname
MsgBox y.myaddress
MsgBox y.myaddress.city
MsgBox y.myaddress.postcode
'Stop
End Sub

浙公网安备 33010602011771号