第1步：先建立一张中英对照表：

let

源 = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45Wet64+vm6tUo6SkX5ydmpJcVKsTrRSi9nt7zcuR8omFSanA0Retrd/nTxaqBQeWJRUWZ+EUT02c5pT3btAormJGanQsWe98x+uW8myMTEghKYwqeta553zgabmJMDFIoFAA==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type text) meta [Serialized.Text = true]) in type table [#"列 1" = _t, #"列 2" = _t]),

更改的类型 = Table.TransformColumnTypes(源,{{"列 1", type text}, {"列 2", type text}}),

重命名的列 = Table.RenameColumns(更改的类型,{{"列 1", "中文名"}, {"列 2", "英文名"}})

in

重命名的列

第2步：编写爬取函数：

(team as text )=>

let

change= Table.SelectRows(中英对照表,each [中文名]=team)[英文名]{0},

源 = Web.Page(Web.Contents("https://china.nba.com/teams/stats/#!/"&change)){0}[Data]

in

源