Get data from row into an array

Question

a really quick question... I want to read rows in sheets one by one, (preferably 'live' so rather than putting it in an array or something). Besides using a loop, how do I read the contents of a whole row? Is it even possible?

Possible duplicate of [Retrieve rows from spreadsheet data using google app script](http://stackoverflow.com/questions/10518084/retrieve-rows-from-spreadsheet-data-using-google-app-script) — Sujay Phadke, Mar 20 '17 at 12:24
You might consider setting up a separate sheet that will filter the row you are interested in instead of using Google Apps scripts. — ScampMichael, Mar 20 '17 at 16:33

Cooper · Answer 1 · 2020-02-29T22:51:13.797

7

You can read about it here

function readData() {
  var sht = SpreadsheetApp.getActiveSheet();
  var rng = sht.getRange(rownumber, 1, 1, numberofcolums)
  var rangeArray = rng.getValues();
//now all your data for that row is in a two Dimensional array [[1,2,3,4,'My Data','etc']]  

}

edited Feb 29 '20 at 22:51

answered Mar 20 '17 at 14:47

Cooper

59,616
6
23
54

score 2 · Answer 2 · answered Nov 27 '18 at 17:01

2

var
  spreadsheetID =
    "1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgvE2upms",
  rowNum = 1,
  rowVals =
    SpreadsheetApp.openById(spreadsheetID)
    .getRange(rowNum +":"+ rowNum)
    .getValues()
;

The other answers to date don't get a row, they get a range of specfic columns within a row. The code in this answer gets the entire unbounded row.

answered Nov 27 '18 at 17:01

Matthew

757
11
19

This still seems to be returning an array within an array, no? I did sheet.getRange('1:1').getValues() and I had to access the inner array with [0]. – Rivers Cuomo Jan 02 '22 at 23:10
Rivers Cuomo: The Range is always a 2D array of row arrays. – Matthew Jan 04 '22 at 15:05

score 1 · Answer 3 · edited May 23 '17 at 10:30

Not sure exactly what your end goal is, but I assume you mean something like this:

      var values = sheet.getRange(startRow, startCol, numRows, numCols).getValues(); // returns 2d array

      values.forEach(function(row){

             Logger.log(row); // prints the contents of the row

          });

You could also use the getCell() method of the Range class to iterate over cells in a range. The return type for getCell() is also Range. See this thread for details on the implementation Google Spreadsheets: Iterate over range, append string to each

Get data from row into an array

3 Answers3