blocks|key|155193|text|如果你只是简单地使用：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|155194|var+values+=+SpreadsheetApp.getActiveSheet().getDataRange().getValues()|offset|length|style|CODE|155195|您将获得工作表中按行和列索引的所有数据的二维数组。|155196|因此，要获取A列中的值，您可以使用values[0][0]，values[1][0]+row1+columnA，第2行，values[0][2]表示C列row1，依此类推...|155197|如果需要在for循环中迭代(在单个列中)：|155198|for(n=0;n<values.length;%2B%2Bn){
var+cell+=+values[n][x]+;+//+x+is+the+index+of+the+column+starting+from+0
}|code-block|syntax|javascript|155199|如果需要在for循环中迭代(在单行中)：|155200|for(n=0;n<values[0].length;%2B%2Bn){
var+cell+=+values[x][n]+;+//+x+is+the+index+of+the+row+starting+from+0
}|155201|entityMap^0|0|0|1Z|0|0|H|C|U|C|1O|C|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|Y|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|Z|8|@$D|10|E|11|F|G]]|9|@]|A|$]]|$1|H|3|I|5|6|7|12|8|@]|9|@]|A|$]]|$1|J|3|K|5|6|7|13|8|@$D|14|E|15|F|G]|$D|16|E|17|F|G]|$D|18|E|19|F|G]]|9|@]|A|$]]|$1|L|3|M|5|6|7|1A|8|@]|9|@]|A|$]]|$1|N|3|O|5|P|7|1B|8|@]|9|@]|A|$Q|R]]|$1|S|3|T|5|6|7|1C|8|@]|9|@]|A|$]]|$1|U|3|V|5|P|7|1D|8|@]|9|@]|A|$Q|R]]|$1|W|3|-4|5|6|7|1E|8|@]|9|@]|A|$]]]|X|$]]

if you use simply :

<code>var values = SpreadsheetApp.getActiveSheet().getDataRange().getValues()</code> 

You will get a 2 Dimension array of all the data in the sheet indexed by rows and columns.

So to get the value in column A, row1 you use <code>values[0][0]</code> , <code>values[1][0]</code> for columnA, row 2, <code>values[0][2]</code> for column C row1, etc...

If you need to iterate in a for loop (in a single column) :

<pre><code>for(n=0;n&lt;values.length;++n){
var cell = values[n][x] ; // x is the index of the column starting from 0
}
</code></pre>

If you need to iterate in a for loop (in a single row) :

<pre><code>for(n=0;n&lt;values[0].length;++n){
var cell = values[x][n] ; // x is the index of the row starting from 0
}
</code></pre>

blocks|key|373276|text|循环各行并获取列值的方法要简单得多。希望这能有所帮助|type|unstyled|depth|inlineStyleRanges|entityRanges|data|373277|var+values+=+SpreadsheetApp.getActiveSheet().getDataRange().getValues();

values.forEach(+function(row)+{
++row[4]+//+column+index+as+4
});|code-block|syntax|javascript|373278|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

much easier way to loop through the rows and get a column value.. hope that helps

<pre><code>var values = SpreadsheetApp.getActiveSheet().getDataRange().getValues();

values.forEach( function(row) {
 row[4] // column index as 4
});
</code></pre>

blocks|key|155413|text|下面是我用来获取动态列中的值的脚本：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|155414|var+SS+=+SpreadsheetApp.getActiveSheet()
var+Avals+=+SS.getRange("A1:A").getValues();
var+numberOfValues+=+Avals.filter(String).length;
var+RangeVals+=+SS.getRange(1,1,numberOfValues).getValues();|code-block|syntax|javascript|155415|不过，我从来不需要根据动态变化的起始点来更改起始行。会有兴趣看看如何做到这一点。|155416|下面是一个类似的post。另一个例子是here。|offset|length|155417|entityMap|0|LINK|mutability|MUTABLE|url|https://stackoverflow.com/questions/44562592/google-script-get-last-row-of-specific-column|1|https://stackoverflow.com/questions/43108046/google-script-reducing-execution-time-below-exec-time-limit^0|0|0|0|8|4|0|J|4|1|0^^$0|@$1|2|3|4|5|6|7|W|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|X|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|Y|8|@]|9|@]|A|$]]|$1|I|3|J|5|6|7|Z|8|@]|9|@$K|10|L|11|1|12]|$K|13|L|14|1|15]]|A|$]]|$1|M|3|-4|5|6|7|16|8|@]|9|@]|A|$]]]|N|$O|$5|P|Q|R|A|$S|T]]|U|$5|P|Q|R|A|$S|V]]]]

Here is the script I use to get the values in a dynamic column:

<pre><code>var SS = SpreadsheetApp.getActiveSheet()
var Avals = SS.getRange("A1:A").getValues();
var numberOfValues = Avals.filter(String).length;
var RangeVals = SS.getRange(1,1,numberOfValues).getValues();
</code></pre>

I've never had to change which starting row based based on a dynamic changing starting point though. Would be interested in seeing how that would be done.

Here is a similar <a href="https://stackoverflow.com/questions/44562592/google-script-get-last-row-of-specific-column">post</a>.
Another example <a href="https://stackoverflow.com/questions/43108046/google-script-reducing-execution-time-below-exec-time-limit">here</a>.

blocks|key|373540|text|假设您希望使用getRange(a1Notation)的列A中的所有行/单元格|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|373541|++var+values+=+SpreadsheetApp.getActiveSheet().getRange("A:A").getValues();|code-block|syntax|javascript|373542|entityMap|0|LINK|mutability|MUTABLE|url|https://developers.google.com/apps-script/reference/spreadsheet/sheet#getrangea1notation^0|T|1|7|K|0|0|0^^$0|@$1|2|3|4|5|6|7|S|8|@$9|T|A|U|B|C]]|D|@$9|V|A|W|1|X]]|E|$]]|$1|F|3|G|5|H|7|Y|8|@]|D|@]|E|$I|J]]|$1|K|3|-4|5|6|7|Z|8|@]|D|@]|E|$]]]|L|$M|$5|N|O|P|E|$Q|R]]]]

Suppose you want all rows/cells in column <code>A</code> using <a href="https://developers.google.com/apps-script/reference/spreadsheet/sheet#getrangea1notation" rel="noreferrer">getRange(a1Notation)</a>:
<pre><code> var values = SpreadsheetApp.getActiveSheet().getRange(&quot;A:A&quot;).getValues();
</code></pre>

blocks|key|373575|text|我认为这是到目前为止最好的答案。假设您想要列"D1:D“的值|type|unstyled|depth|inlineStyleRanges|entityRanges|data|373576|var+numrows+=+SpreadsheetApp.getActiveSpreadsheet().getDataRange().getNumRows();
var+columnValues+=+sheet.getRange(1,4,numrows,1).getValues();|code-block|syntax|javascript|373577|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

I think this is the best answer so far. Suppose you want the values of Column &quot;D1:D&quot;
<pre><code>var numrows = SpreadsheetApp.getActiveSpreadsheet().getDataRange().getNumRows();
var columnValues = sheet.getRange(1,4,numrows,1).getValues();
</code></pre>

I want to get a string value -to compare it later on with an if condition- from only one column in spreadsheet using Google apps script.
I searched the internet and I found this link - sorry if this sounds stupid, I am new to Google apps scripts - <a href="https://developers.google.com/apps-script/class_spreadsheet">https://developers.google.com/apps-script/class_spreadsheet</a>

<pre><code>var values = SpreadsheetApp.getActiveSheet().getRange(2, 3, 6, 4).getValues(); 
</code></pre>

I guess that must be helpful, the only problem is that the column I want to get the values from is dynamic so how do I set the range of this column

get value in one column in spreadsheet using google apps script

我想得到一个字符串值，然后用一个if条件进行比较--只从电子表格中的一列使用-to脚本。我在互联网上搜索了一下，发现了这个链接--抱歉，如果这听起来很愚蠢，我是谷歌应用脚本的新手-- var values = SpreadsheetApp.getActiveSheet().getRange(2, 3, 6, 4).ge...

问使用google应用程序脚本在电子表格的一列中获取值
EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问使用google应用程序脚本在电子表格的一列中获取值EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问使用google应用程序脚本在电子表格的一列中获取值
EN