生成音标:=IF(A1="","",FILTERXML(WEBSERVICE("http://dict.youdao.com/search?q="&A1&"&doctype=xml"),"//phonetic-symbol"))
生成翻译(不全):=IF(A1="","",FILTERXML(WEBSERVICE("http://fanyi.youdao.com/translate?&i="&A1&"&doctype=xml"),"//translation"))
如果没有就网络上抓
本回答被网友采纳