等价于Google Apps脚本中的"= Query(ImportRange("? [英] Equivalent of "=Query(ImportRange(" in Google Apps Script?

问题描述

例如在新的Google工作表中，我有以下公式:

For example in the new google sheet I have these formulas :

= Query(ImportRange("ehd54 ... dfdfg"，'Sheet1'！A:C")，选择*其中Col1 ='COM'限制5"，1))

= Query(ImportRange("ehd54 ... dfdfg"，'Sheet1'！A:C")，选择*其中Col2包含'IS_A_NAME'限制5")

注意:

• 我不想使用set.Formula(Query(ImportRange(...

• I don't want to use set.Formula(Query(ImportRange(...

我已经看到我可以在此处执行等效的importrange:

I have seen that I can do the equivalent of importrange here: Is it possible to do ImportRange in Google Apps Script? but I am blocked for Query.

我的importrange工作表大约有30,000行，少于5列.

my importrange sheets have about 30,000 rows and less than 5 columns.

推荐答案

导入"数据后，请使用

Once you've "imported" the data, use the 2D Array Library to filter it, then write the results to your sheet.

这篇关于等价于Google Apps脚本中的"= Query(ImportRange("?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！