使用IMPORTRANGE作为数组公式 [英] Using IMPORTRANGE as an array formula

问题描述

我在一个单元格中有一个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 performance hit 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作为数组公式的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！