拼音转汉字

原理:

导出输入法词库，通过Web.Contents调用，根据输入法词库匹配由拼音组成的汉字

方法:

新建自定义函数：

py = (x)=>
    let
        source = Csv.Document(Web.Contents("https://pqfans.com/pq/pinyin/py.txt"),[Delimiter=" ", Columns=2]),
        replace = Table.ReplaceValue(source,"'","",Replacer.ReplaceText,{"Column1"}),
        result = try replace[Column2]{List.PositionOf(replace[Column1],x)} otherwise x
    in
        result

示例: