我尝试过IMPORTXML函数我的代码:
=IMPORTXML("https://dictionary.cambridge.org/dictionary/english/*C2*","getElementsByTagName(name)[0];y = x.childNodes[0];z = y.nodeValue", "en_US")
C2是小区名称的占位符
而不是
"https://dictionary.cambridge.org/dictionary/english/*C2*"
使用
"https://dictionary.cambridge.org/dictionary/english/"&C2