如何忽略getRange()的空单元格值getValues() [英] How to ignore empty cell values for getRange().getValues()
本文介绍了如何忽略getRange()的空单元格值getValues()的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我可以使用getValues()获取范围值,并通过在Google App脚本中声明以下变量将其放入字符串中:
var ss = SpreadsheetApp.getActiveSpreadsheet();
var sheet = ss.getSheetByName(Test);
var range_input = ss.getRange(A1:A)。getValues();
然而,我意识到我可能从所有空的调用中获得了很多逗号。
例如,如果数值如下
==== ============
Spreadsheet(Test)值
A1 = abc
A2 = def
A3 =
A4 =
A5 =
A6 = uvw
A7 = xyz
================
如果我使用msgBox,它会得到如下所示的结果。
Browser.msgBox(range_input)// results = abc,def ,,,, uvw,xyz ,,,,,,,,,,,
是否有办法删除尾随逗号,以便得到类似下面的内容?
(即忽略空单元格)
Browser.msgBox(range_input)// results = abc,def,uvw ,xyz
解决方案
这个样本怎么样?
示例:
var ss = SpreadsheetApp.getActiveSpreadsheet ();
var sheet = ss.getSheetByName(Test);
var range_input = ss.getRange(A1:A)。getValues();
var result = [i for each(i in range_input)if(isNaN(i))];
Browser.msgBox(result)
I am able to get the range values using getValues() and put it into a string by declaring the following variables in Google App Script
var ss = SpreadsheetApp.getActiveSpreadsheet();
var sheet = ss.getSheetByName("Test");
var range_input = ss.getRange("A1:A").getValues();
However, I realize I am getting a lot of commas in my string probably from all the empty calls.
For example, if values are following
================
Spreadsheet("Test") Values
A1=abc
A2=def
A3=
A4=
A5=
A6=uvw
A7=xyz
================
If I do msgBox, it gets something like below.
Browser.msgBox(range_input) // results = abc,def,,,,uvw,xyz,,,,,,,,,,,
Is there a way to remove the trailing commas so I get something like below? (i.e. ignore the empty cells)
Browser.msgBox(range_input) // results = abc,def,uvw,xyz
解决方案
How about this sample?
Sample :
var ss = SpreadsheetApp.getActiveSpreadsheet();
var sheet = ss.getSheetByName("Test");
var range_input = ss.getRange("A1:A").getValues();
var result = [i for each (i in range_input)if (isNaN(i))];
Browser.msgBox(result)
这篇关于如何忽略getRange()的空单元格值getValues()的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文