How to put data into a 2D array in google script / javascript?

Question

I am trying to make an array such that it looks like

[[name,result],[name,result],[name,result],......[name,result]]

with the for loop changing the name and result.

I am getting this error: TypeError: Cannot set property '0' of undefined at array[i][0] = name;

Code:

function one(){
  var ss = SpreadsheetApp.getActiveSpreadsheet();
  var sheet = ss.getSheetByName("123aaa");
  var num_of_samples = 5;
  var array=[[],[]];

  for(i=1; i <= num_of_samples; i++){

    var name = sheet.getRange(2*i+6,2).getValue();
    var result = sheet.getRange(2*i+7,2).getValue();
    array[i][0] = name;
    array[i][1] = result;
  }
  Logger.log(array);

}

Cooper · Accepted Answer · 2021-07-29 21:07:10Z

2

function one() {
  var ss = SpreadsheetApp.getActive();
  var sheet = ss.getSheetByName("123aaa");
  var num_of_samples = 5;
  var array = [];
  for (i = 1; i <= 5; i++) {
    array.push([`Name${i}`, `Result${i}`]);
  }
  Logger.log(array);
}

Execution log
3:06:45 PM  Notice  Execution started
3:06:46 PM  Info    [[Name1, Result1], [Name2, Result2], [Name3, Result3], [Name4, Result4], [Name5, Result5]]
3:06:46 PM  Notice  Execution completed

answered Jul 29, 2021 at 21:07

Cooper

64.2k7 gold badges28 silver badges65 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to put data into a 2D array in google script / javascript?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related