【在循环中抓取数据】为什么进入循环以后抓取数据只能抓取首页的数据
有没有老师可以教一下，第一次会按照设定的页数来抓取，进入循环以后只会采取第一页的数据。要怎么修改才可以每次循环都可以抓取前10页的内容呢？
dTime = Time.Now()
sRet = Time.Format(dTime,"yy-mm-dd")
objExcelWorkBook = Excel.BindBook("灯塔评价采集.xlsx")
iRet = Excel.GetRowsCount(objExcelWorkBook,"NameiQ")
a = 1
Do While a <= iRet
gnumber=Excel.ReadCell(objExcelWorkBook,"NameiQ","A" & a,true)
gname=Excel.ReadCell(objExcelWorkBook,"NameiQ","B" & a,true)
Excel.CreateSheet(objExcelWorkBook,gname&sRet,"after",false)
hWeb = WebBrowser.BindBrowser("chrome",10000,{"bContinueOnError":false,"iDelayAfter":300,"iDelayBefore":200})
Keyboard.InputText(@ui"输入控件<input>",gnumber,true,20,10000,{"bContinueOnError": false, "iDelayAfter": 300, "iDelayBefore": 500, "bSetForeground": true, "sSimulate": "message", "bValidate": false, "bClickBeforeInput": false})
Mouse.Action(@ui"svg","left","click",10000,{"bContinueOnError": false, "iDelayAfter": 300, "iDelayBefore": 200, "bSetForeground": true, "sCursorPosition": "Center", "iCursorOffsetX": 0, "iCursorOffsetY": 0, "sKeyModifiers": [],"sSimulate": "simulate", "bMoveSmoothly": false})
arrayData = UiElement.DataScrap({"wnd":[{"cls":"Chrome_WidgetWin_1","title":"*","app":"chrome"},{"cls":"Chrome_RenderWidgetHostHWND","title":"Chrome Legacy Window"}],"html":[{"tag":"DIV","id":"cvContentRoot"}]},{"ExtractTable":0,"Columns":[{"selecors":[{"tag":"div","index":0,"className":"evaluation-management-container","value":"div.evaluation-management-container","prefix":""},{"tag":"div","index":0,"className":"evaluation-list-container","value":"div.evaluation-list-container","prefix":">"},{"tag":"div","index":0,"className":"table-container","value":"div.table-container","prefix":">"},{"tag":"div","index":0,"className":"ant-table-wrapper no-hover","value":"div.ant-table-wrapper.no-hover","prefix":">"},{"tag":"div","index":0,"className":"ant-spin-nested-loading","value":"div.ant-spin-nested-loading","prefix":">"},{"tag":"div","index":0,"className":"ant-spin-container","value":"div.ant-spin-container","prefix":">"},{"tag":"div","index":0,"className":"ant-table","value":"div.ant-table","prefix":">"},{"tag":"div","index":0,"className":"ant-table-container","value":"div.ant-table-container","prefix":">"},{"tag":"div","index":0,"className":"ant-table-content","value":"div.ant-table-content","prefix":">"},{"tag":"table","index":0,"className":"","value":"table","prefix":">"},{"tag":"tbody","index":0,"className":"ant-table-tbody","value":"tbody.ant-table-tbody","prefix":">"},{"tag":"tr","value":"tr","index":0,"prefix":">"},{"tag":"td","index":0,"className":"ant-table-cell first-td","value":"td.ant-table-cell.first-td","prefix":">"},{"tag":"div","index":0,"className":"cell-row","value":"div.cell-row","prefix":">"},{"tag":"div","index":0,"className":"header","value":"div.header","prefix":">"},{"tag":"span","index":0,"className":"id","value":"span.id","prefix":">"},{"tag":"span","index":2,"className":"","value":"span:nth-child(2)","prefix":">"}],"props":["text"]},{"selecors":[{"tag":"div","index":0,"className":"evaluation-management-container","value":"div.evaluation-management-container","prefix":""},{"tag":"div","index":0,"className":"evaluation-list-container","value":"div.evaluation-list-container","prefix":">"},{"tag":"div","index":0,"className":"table-container","value":"div.table-container","prefix":">"},{"tag":"div","index":0,"className":"ant-table-wrapper no-hover","value":"div.ant-table-wrapper.no-hover","prefix":">"},{"tag":"div","index":0,"className":"ant-spin-nested-loading","value":"div.ant-spin-nested-loading","prefix":">"},{"tag":"div","index":0,"className":"ant-spin-container","value":"div.ant-spin-container","prefix":">"},{"tag":"div","index":0,"className":"ant-table","value":"div.ant-table","prefix":">"},{"tag":"div","index":0,"className":"ant-table-container","value":"div.ant-table-container","prefix":">"},{"tag":"div","index":0,"className":"ant-table-content","value":"div.ant-table-content","prefix":">"},{"tag":"table","index":0,"className":"","value":"table","prefix":">"},{"tag":"tbody","index":0,"className":"ant-table-tbody","value":"tbody.ant-table-tbody","prefix":">"},{"tag":"tr","value":"tr","index":0,"prefix":">"},{"tag":"td","index":0,"className":"ant-table-cell first-td","value":"td.ant-table-cell.first-td","prefix":">"},{"tag":"div","index":0,"className":"cell-row","value":"div.cell-row","prefix":">"},{"tag":"div","index":0,"className":"ant-table-wrapper","value":"div.ant-table-wrapper","prefix":">"},{"tag":"div","index":0,"className":"ant-spin-nested-loading","value":"div.ant-spin-nested-loading","prefix":">"},{"tag":"div","index":0,"className":"ant-spin-container","value":"div.ant-spin-container","prefix":">"},{"tag":"div","index":0,"className":"ant-table","value":"div.ant-table","prefix":">"},{"tag":"div","index":0,"className":"ant-table-container","value":"div.ant-table-container","prefix":">"},{"tag":"div","index":0,"className":"ant-table-content","value":"div.ant-table-content","prefix":">"},{"tag":"table","index":0,"className":"","value":"table","prefix":">"},{"tag":"tbody","index":0,"className":"ant-table-tbody","value":"tbody.ant-table-tbody","prefix":">"},{"tag":"tr","index":0,"className":"ant-table-row ant-table-row-level-0","value":"tr.ant-table-row.ant-table-row-level-0","prefix":">"},{"tag":"td","index":0,"className":"ant-table-cell evaluation","value":"td.ant-table-cell.evaluation","prefix":">"},{"tag":"div","index":0,"className":"evaluation-cell","value":"div.evaluation-cell","prefix":">"},{"tag":"div","index":0,"className":"evaluation-item False ","value":"div.evaluation-item.false","prefix":">"},{"tag":"div","index":0,"className":"evaluation-wrapper","value":"div.evaluation-wrapper","prefix":">"},{"tag":"div","index":0,"className":"head","value":"div.head","prefix":">"},{"tag":"span","index":0,"className":"createTime","value":"span.createTime","prefix":">"}],"props":["text"]},{"selecors":[{"tag":"div","index":0,"className":"evaluation-management-container","value":"div.evaluation-management-container","prefix":""},{"tag":"div","index":0,"className":"evaluation-list-container","value":"div.evaluation-list-container","prefix":">"},{"tag":"div","index":0,"className":"table-container","value":"div.table-container","prefix":">"},{"tag":"div","index":0,"className":"ant-table-wrapper no-hover","value":"div.ant-table-wrapper.no-hover","prefix":">"},{"tag":"div","index":0,"className":"ant-spin-nested-loading","value":"div.ant-spin-nested-loading","prefix":">"},{"tag":"div","index":0,"className":"ant-spin-container","value":"div.ant-spin-container","prefix":">"},{"tag":"div","index":0,"className":"ant-table","value":"div.ant-table","prefix":">"},{"tag":"div","index":0,"className":"ant-table-container","value":"div.ant-table-container","prefix":">"},{"tag":"div","index":0,"className":"ant-table-content","value":"div.ant-table-content","prefix":">"},{"tag":"table","index":0,"className":"","value":"table","prefix":">"},{"tag":"tbody","index":0,"className":"ant-table-tbody","value":"tbody.ant-table-tbody","prefix":">"},{"tag":"tr","value":"tr","index":0,"prefix":">"},{"tag":"td","index":0,"className":"ant-table-cell first-td","value":"td.ant-table-cell.first-td","prefix":">"},{"tag":"div","index":0,"className":"cell-row","value":"div.cell-row","prefix":">"},{"tag":"div","index":0,"className":"ant-table-wrapper","value":"div.ant-table-wrapper","prefix":">"},{"tag":"div","index":0,"className":"ant-spin-nested-loading","value":"div.ant-spin-nested-loading","prefix":">"},{"tag":"div","index":0,"className":"ant-spin-container","value":"div.ant-spin-container","prefix":">"},{"tag":"div","index":0,"className":"ant-table","value":"div.ant-table","prefix":">"},{"tag":"div","index":0,"className":"ant-table-container","value":"div.ant-table-container","prefix":">"},{"tag":"div","index":0,"className":"ant-table-content","value":"div.ant-table-content","prefix":">"},{"tag":"table","index":0,"className":"","value":"table","prefix":">"},{"tag":"tbody","index":0,"className":"ant-table-tbody","value":"tbody.ant-table-tbody","prefix":">"},{"tag":"tr","index":0,"className":"ant-table-row ant-table-row-level-0","value":"tr.ant-table-row.ant-table-row-level-0","prefix":">"},{"tag":"td","index":0,"className":"ant-table-cell evaluation","value":"td.ant-table-cell.evaluation","prefix":">"},{"tag":"div","index":0,"className":"evaluation-cell","value":"div.evaluation-cell","prefix":">"},{"tag":"div","index":0,"className":"evaluation-item false ","value":"div.evaluation-item.false","prefix":">"},{"tag":"div","index":0,"className":"evaluation-wrapper","value":"div.evaluation-wrapper","prefix":">"},{"tag":"div","index":0,"className":"comment","value":"div.comment","prefix":">"},{"tag":"div","index":0,"className":"content","value":"div.content","prefix":">"}],"props":["text"]}]},{"objNextLinkElement":{"wnd":[{"cls":"Chrome_WidgetWin_1","title":"*","app":"chrome"},{"cls":"Chrome_RenderWidgetHostHWND","title":"Chrome Legacy Window"}],"html":[{"tag":"svg","parentid":"cvContentRoot","css-selector":"body>div>div>div>section>section>div>div>div>div>div>div>ul>li>button>span>svg","idx":1}]},"iMaxNumberOfPage":20,"iMaxNumberOfResult":-1,"iDelayBetweenMS":1000,"bContinueOnError":false})
Excel.WriteCell(objExcelWorkBook,gname&sRet,"A1",arrayData,false)
a = a + 1
Loop
Excel.Save(objExcelWorkBook)
最新回复 (1)
-
EchO_wjy 11月前2楼循环之后没有再次点击翻页？