这个是其他语言的代码、要如何修改才能工作?谢谢大家!
Sub West()
Dim result, antistop, Values As Variant, i, j, x, y, cnt
Dim Json As Object
cnt = Range("b1") & ""
antistop = "{""question"":""ROE>20"",""perpage"":" & cnt & ",""page"":9,""secondary_intent"":""stock"",""log_info"":""{\""input_type\"":\""click\""}"",""source"":""Ths_iwencai_Xuangu"",""version"":""2.0"",""query_area"":"""",""block_list"":"""",""add_info"":""{\""urp\"":{\""scene\"":1,\""company\"":1,\""business\"":1},\""contentType\"":\""json\"",\""searchInfo\"":true}""}"
With CreateObject("WinHttp.WinHttpRequest.5.1")
.Open "Post", "http://x.10jqka.com.cn/customized/chart/get-robot-data", False
.setRequestHeader "User-Agent", "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/97.0.4692.71 Safari/537.36"
.setRequestHeader "Content-Type", "application/json"
.send antistop
result = Split(Split(.responsetext, """datas"":")(1), ",""meta")(0)
Set Json = JsonConverter.ParseJson(result)
End Sub