如何把数据到一个2D数组在谷歌脚本/ javascript?

Question

我正在尝试创建一个数组，使其看起来像

[[名字,结果],[名字,结果],[名字,结果],……[名字,结果]]

使用for循环更改名称和结果。

我得到这个错误:TypeError:无法在array[i][0] = name;

设置未定义的属性'0'代码:

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);
}

Answer 1

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