|
[广告] Excel易用宝 - 提升Excel的操作效率 · Excel / WPS表格插件 ★ 免费下载 ★ ★ 使用帮助★
如何自动填写表单与传递网页参数,帮忙,在线等。
某网页https://113187.yichafen.com/public/queryscore/sqcode/MsTcAn4mMzAyMHw3MDdiOWMzYmE0NTFmODRhZmFhYmFhOWMwZDg4MWU2YXwxMTMxODcO0O0O.html
如下图需要自动填写:姓名 李四 手机号:13757756620
查询其考勤数据或得分情况,POST参数如何编写,请大侠们帮个忙,谢谢。
表单
Set oDom = CreateObject("htmlfile")
Set oWindow = oDom.parentWindow
Set oHttp = CreateObject("winHttp.winHttpRequest.5.1")
URL = "https://113187.yichafen.com/public/queryscore/sqcode/MsTcAn4mMzAyMHw3MDdiOWMzYmE0NTFmODRhZmFhYmFhOWMwZDg4MWU2YXwxMTMxODcO0O0O.html"
oHttp.Open "GET", URL
oHttp.setRequestheader "Accept-Language", "zh-CN,zh;q=0.8,en-US;q=0.5,en;q=0.3"
oHttp.send
oDom.body.innerHtml = oHttp.responseText
' pd1 = oDom.getElementById("s_xingming").Value
pd1 = Sheet1.Cells(4, 2): pd2 = Sheet1.Cells(4, 3) ’--PD1=李四 PD2=手机号
oDom.getElementById("s_xingming").Value = pd1
oDom.getElementById("s_shoujihaoma").Value = pd2
PostData = "" 请完善参数传递,如何编写????
oHttp.Open "POST", URL, False
oHttp.setRequestheader "Content-Type", "application/x-www-form-urlencoded"
oHttp.send (PostData)
stext = oHttp.responseText
Sheet1.Cells(1, 1) = stext '页面已拷贝至剪切板,可粘贴到记事本中查看
结果返回
才是正确!
|
|