|
本帖最后由 joeeeeee 于 2019-12-13 12:42 编辑
目标网址:https://info.sporttery.cn/football/match_result.php?page=1&search_league=25&start_date=2009-04-28&end_date=2019-12-13&dan=0
我按照这个教程:https://www.jianshu.com/p/03e8879ec9b8一步一步做但是结果总是重复抓取第一页数据。。
高级编辑器里的代码:
(p as number) as table =>
let
源 = Web.Page(Web.Contents("https://info.sporttery.cn/football/match_result.php?page=" & "(Number.ToText(p))" & "&search_league=25&start_date=2009-04-28&end_date=2019-12-13&dan=0")),
Data1 = 源{1}[Data],
更改的类型 = Table.TransformColumnTypes(Data1,{{"Column1", type text}, {"Column2", type text}, {"Column3", type text}, {"Column4", type text}, {"Column5", type text}, {"Column6", type text}, {"Column7", type text}, {"Column8", type text}, {"Column9", type text}, {"Column10", type text}, {"Column11", type text}, {"Column12", type text}})
in
更改的类型
恳求各位大神高手解答一下🐮🐮🐮
|
|