等价于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(...
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屋!