使用 importXML from column of URLs with arrayformula 在谷歌表中返回相同的重复结果 [英] Use importXML from column of URLs with arrayformula returning same duplicated result in google sheet

问题描述

我已成功使用 ImportXML 获取带有 Google 表格中 URL 的 Youtube 视频的标题.这是我的代码:

I have succeeded in using ImportXML to get the title of the Youtube videos with URLs in Google Sheets. Here is my code:

=IF(ISBLANK(A3:A),"",IMPORTXML(A3:A, "//*[@id='eow-title']"))

但是，当我尝试在 ImportXML 中应用 ArrayFormula 时，它一遍又一遍地返回第一列的结果.

However, when I tried to apply ArrayFormula in ImportXML, it returned the result of the first column, over and over again.

=ArrayFormula(IF(ISBLANK(A3:A),"",IMPORTXML(A3:A, "//*[@id='eow-title']")))

喜欢下图:(请看D列)

Like the following image: (Please have a look at column D)

我希望 D 列的输出可以自动计算并返回 A 列中不同 Youtube URL 的正确标题.

I expect the output of column D could automatically calculate and return the correct title of different Youtube URLs from column A.

任何建议将不胜感激

推荐答案

https://support.google.com/docs/forum/AAAABuH1jm0XzeSrif_I1Q/?hl=sv

ARRAYFORMULA 不支持 IMOPRTXML、IMPORTHTML.

ARRAYFORMULA does not support IMOPRTXML, IMPORTHTML.

我使用:

=iferror(IMPORTXML(A3,"//*[@id='eow-title']"),"") + @CTRL-C @CTRL-V

这篇关于使用 importXML from column of URLs with arrayformula 在谷歌表中返回相同的重复结果的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！