我如何拼接一个二维数组在谷歌应用程序脚本?

Question

我试图在谷歌应用程序脚本拼接二维数组。我有以下代码，但它只适用于1D数组:

function trimArray() {
var myArray = ['1', '2', '3', '4', '5', '6,', '7', '8', '9', '10'];
myArray.splice(3, myArray.length);
console.log(myArray);
}

我如何修改上面的代码来使用这个数组?

[['1', '2', '3', '4', '5', '6,', '7', '8', '9', '10']]

输出应该与上面的函数相同，但仍然保持一个2D数组:

[['1', '2', '3']]

Answer 1

试试这个

function test() {
try {
let a = [['1', '2', '3', '4', '5', '6,', '7', '8', '9', '10']];
a[0] = a[0].slice(0,3);
console.log(a)
}
catch(err) {
console.log("Error in test: "+err);
}
}
2:59:19 PM  Notice  Execution started
2:59:20 PM  Info    [ [ '1', '2', '3' ] ]
2:59:20 PM  Notice  Execution completed

Answer 2

试试这个:

function splicearray() {
let arr = [[1,2,3],[7,8,9]];
arr.splice(1,0,[4,5,6]);
Logger.log(arr);
}
Execution log
2:11:54 PM  Notice  Execution started
2:11:54 PM  Info    [[1.0, 2.0, 3.0], [4.0, 5.0, 6.0], [7.0, 8.0, 9.0]]
2:11:55 PM  Notice  Execution completed

我不明白你的例子，如果我想留下一个二维数组，正如你所示，我会这样做:

function trimArray() {
let arr = [['1', '2', '3', '4', '5', '6,', '7', '8', '9', '10']];
arr.splice(0,1, [1,2,3]);
Logger.log(arr);
}
Execution log
2:23:26 PM  Notice  Execution started
2:23:26 PM  Info    [[1.0, 2.0, 3.0]]
2:23:27 PM  Notice  Execution completed