上一帖使用web page wen content, 這個帖子用Web.BrowserContents

唯一區(qū)別!!! 所有隊伍的內(nèi)容都可以爬取到,沒有null, 這一點(diǎn)比web page web content好

在上一帖中,重復(fù)的步驟就直接跳過:

自定義公式 寫: "

let

源 = Web.BrowserContents("https://china.nba.com/teams/stats/#!/"&[英文]),

#"從 Html 中提取的表" = Html.Table(源, {{"Column1", "DIV.ng-scope:nth-child(1) > NBA-STAT-TABLE.team-stats__table.ng-isolate-scope > DIV.nba-stat-table > DIV.nba-stat-table__overflow > TABLE > * > TR > :nth-child(1)"}, {"Column2", "DIV.ng-scope:nth-child(1) > NBA-STAT-TABLE.team-stats__table.ng-isolate-scope > DIV.nba-stat-table > DIV.nba-stat-table__overflow > TABLE > * > TR > :nth-child(2)"}, {"Column3", "DIV.ng-scope:nth-child(1) > NBA-STAT-TABLE.team-stats__table.ng-isolate-scope > DIV.nba-stat-table > DIV.nba-stat-table__overflow > TABLE > * > TR > :nth-child(3)"}, {"Column4", "DIV.ng-scope:nth-child(1) > NBA-STAT-TABLE.team-stats__table.ng-isolate-scope > DIV.nba-stat-table > DIV.nba-stat-table__overflow > TABLE > * > TR > :nth-child(4)"}, {"Column5", "DIV.ng-scope:nth-child(1) > NBA-STAT-TABLE.team-stats__table.ng-isolate-scope > DIV.nba-stat-table > DIV.nba-stat-table__overflow > TABLE > * > TR > :nth-child(5)"}, {"Column6", "DIV.ng-scope:nth-child(1) > NBA-STAT-TABLE.team-stats__table.ng-isolate-scope > DIV.nba-stat-table > DIV.nba-stat-table__overflow > TABLE > * > TR > :nth-child(6)"}, {"Column7", "DIV.ng-scope:nth-child(1) > NBA-STAT-TABLE.team-stats__table.ng-isolate-scope > DIV.nba-stat-table > DIV.nba-stat-table__overflow > TABLE > * > TR > :nth-child(7)"}, {"Column8", "DIV.ng-scope:nth-child(1) > NBA-STAT-TABLE.team-stats__table.ng-isolate-scope > DIV.nba-stat-table > DIV.nba-stat-table__overflow > TABLE > * > TR > :nth-child(8)"}, {"Column9", "DIV.ng-scope:nth-child(1) > NBA-STAT-TABLE.team-stats__table.ng-isolate-scope > DIV.nba-stat-table > DIV.nba-stat-table__overflow > TABLE > * > TR > :nth-child(9)"}, {"Column10", "DIV.ng-scope:nth-child(1) > NBA-STAT-TABLE.team-stats__table.ng-isolate-scope > DIV.nba-stat-table > DIV.nba-stat-table__overflow > TABLE > * > TR > :nth-child(10)"}, {"Column11", "DIV.ng-scope:nth-child(1) > NBA-STAT-TABLE.team-stats__table.ng-isolate-scope > DIV.nba-stat-table > DIV.nba-stat-table__overflow > TABLE > * > TR > :nth-child(11)"}, {"Column12", "DIV.ng-scope:nth-child(1) > NBA-STAT-TABLE.team-stats__table.ng-isolate-scope > DIV.nba-stat-table > DIV.nba-stat-table__overflow > TABLE > * > TR > :nth-child(12)"}, {"Column13", "DIV.ng-scope:nth-child(1) > NBA-STAT-TABLE.team-stats__table.ng-isolate-scope > DIV.nba-stat-table > DIV.nba-stat-table__overflow > TABLE > * > TR > :nth-child(13)"}, {"Column14", "DIV.ng-scope:nth-child(1) > NBA-STAT-TABLE.team-stats__table.ng-isolate-scope > DIV.nba-stat-table > DIV.nba-stat-table__overflow > TABLE > * > TR > :nth-child(14)"}, {"Column15", "DIV.ng-scope:nth-child(1) > NBA-STAT-TABLE.team-stats__table.ng-isolate-scope > DIV.nba-stat-table > DIV.nba-stat-table__overflow > TABLE > * > TR > :nth-child(15)"}, {"Column16", "DIV.ng-scope:nth-child(1) > NBA-STAT-TABLE.team-stats__table.ng-isolate-scope > DIV.nba-stat-table > DIV.nba-stat-table__overflow > TABLE > * > TR > :nth-child(16)"}, {"Column17", "DIV.ng-scope:nth-child(1) > NBA-STAT-TABLE.team-stats__table.ng-isolate-scope > DIV.nba-stat-table > DIV.nba-stat-table__overflow > TABLE > * > TR > :nth-child(17)"}, {"Column18", "DIV.ng-scope:nth-child(1) > NBA-STAT-TABLE.team-stats__table.ng-isolate-scope > DIV.nba-stat-table > DIV.nba-stat-table__overflow > TABLE > * > TR > :nth-child(18)"}, {"Column19", "DIV.ng-scope:nth-child(1) > NBA-STAT-TABLE.team-stats__table.ng-isolate-scope > DIV.nba-stat-table > DIV.nba-stat-table__overflow > TABLE > * > TR > :nth-child(19)"}, {"Column20", "DIV.ng-scope:nth-child(1) > NBA-STAT-TABLE.team-stats__table.ng-isolate-scope > DIV.nba-stat-table > DIV.nba-stat-table__overflow > TABLE > * > TR > :nth-child(20)"}, {"Column21", "DIV.ng-scope:nth-child(1) > NBA-STAT-TABLE.team-stats__table.ng-isolate-scope > DIV.nba-stat-table > DIV.nba-stat-table__overflow > TABLE > * > TR > :nth-child(21)"}, {"Column22", "DIV.ng-scope:nth-child(1) > NBA-STAT-TABLE.team-stats__table.ng-isolate-scope > DIV.nba-stat-table > DIV.nba-stat-table__overflow > TABLE > * > TR > :nth-child(22)"}, {"Column23", "DIV.ng-scope:nth-child(1) > NBA-STAT-TABLE.team-stats__table.ng-isolate-scope > DIV.nba-stat-table > DIV.nba-stat-table__overflow > TABLE > * > TR > :nth-child(23)"}, {"Column24", "DIV.ng-scope:nth-child(1) > NBA-STAT-TABLE.team-stats__table.ng-isolate-scope > DIV.nba-stat-table > DIV.nba-stat-table__overflow > TABLE > * > TR > :nth-child(24)"}, {"Column25", "DIV.ng-scope:nth-child(1) > NBA-STAT-TABLE.team-stats__table.ng-isolate-scope > DIV.nba-stat-table > DIV.nba-stat-table__overflow > TABLE > * > TR > :nth-child(25)"}, {"Column26", "DIV.ng-scope:nth-child(1) > NBA-STAT-TABLE.team-stats__table.ng-isolate-scope > DIV.nba-stat-table > DIV.nba-stat-table__overflow > TABLE > * > TR > :nth-child(26)"}, {"Column27", "DIV.ng-scope:nth-child(1) > NBA-STAT-TABLE.team-stats__table.ng-isolate-scope > DIV.nba-stat-table > DIV.nba-stat-table__overflow > TABLE > * > TR > :nth-child(27)"}, {"Column28", "DIV.ng-scope:nth-child(1) > NBA-STAT-TABLE.team-stats__table.ng-isolate-scope > DIV.nba-stat-table > DIV.nba-stat-table__overflow > TABLE > * > TR > :nth-child(28)"}, {"Column29", "DIV.ng-scope:nth-child(1) > NBA-STAT-TABLE.team-stats__table.ng-isolate-scope > DIV.nba-stat-table > DIV.nba-stat-table__overflow > TABLE > * > TR > :nth-child(29)"}}, [RowSelector="DIV.ng-scope:nth-child(1) > NBA-STAT-TABLE.team-stats__table.ng-isolate-scope > DIV.nba-stat-table > DIV.nba-stat-table__overflow > TABLE > * > TR"]),

提升的標(biāo)題 = Table.PromoteHeaders(#"從 Html 中提取的表", [PromoteAllScalars=true])

in

提升的標(biāo)題

"

后面的 步驟和上一帖內(nèi)容一樣, 篩選 展開結(jié)果等等