问题描述
我在一个单元格中有一个URL，这是IMPORTRANGE的标准.例如:
I have a URL in one cell which is the criterion for the IMPORTRANGE. e.g.:
=IMPORTRANGE(B2,"sheet1!$A$1")
我找到了一个公式来收集它作为准则，但不是在数组版本中.
I found a formula to collect it as criterion, but not in array version.
可以在此处找到.
推荐答案
我看到您在B列中填充了电子表格ID，并且您正在尝试执行
I see you have column B filled with Spreadsheet Ids, and you are trying to execute
=ArrayFormula(IMPORTRANGE(B2:B,"sheet1!$A$1"))
并非每个电子表格函数都支持将数组作为参数.特别是， importrange 不会.对于要导入的单独电子表格，您需要单独的 importrange 公式.
Not every spreadsheet function supports arrays as argument. In particular, importrange does not. You need separate importrange formulas for separate spreadsheets you are importing.
实际上，从另一个电子表格导入数据不是批处理操作；每个导入都必须在第一次调用时通过单击提示进行授权.而且，这是一个非常慢的操作；你会表现得很认真如果尝试导入很多其他电子表格，则按一下.
Indeed, importing data from another spreadsheet is not a batch operation; each import has to be authorized by clicking a prompt the first time it's called. Also, it's a very slow operation; you will get a serious performancehit if trying to import a lot of other spreadsheets.
通常，如果您发现自己做了很多 importrange ，可能是时候重新考虑整个数据的组织了.
Generally, if you find yourself doing a lot of importrange, it may be time to rethink the overall data organization.
这篇关于使用IMPORTRANGE作为数组公式的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！