This is a Sample Array Script for Spreadsheet. It makes an 2D array filled by strings and number. The strings and number are column strings and row number, respectively.
However, because this is a sample, the maximum column number is 26.
function sa(row, col){
if (col > 26) return;
var ar = new Array(row);
for(var i = 0; i < row; i++) ar[i] = new Array(col);
for (var i = 0; i < row; i++){
for (var j = 0; j < col; j++){
ar[i][j] = String.fromCharCode(i + 97) + String(j + 1);
}
}
return ar.map(function(x, i){return x.map(function(y, j){return ar[j][i]})});
}
When “sa(10,10)” is given, following array can be output.
[
[a1, b1, c1, d1, e1, f1, g1, h1, i1, j1],
[a2, b2, c2, d2, e2, f2, g2, h2, i2, j2],
[a3, b3, c3, d3, e3, f3, g3, h3, i3, j3],
[a4, b4, c4, d4, e4, f4, g4, h4, i4, j4],
[a5, b5, c5, d5, e5, f5, g5, h5, i5, j5],
[a6, b6, c6, d6, e6, f6, g6, h6, i6, j6],
[a7, b7, c7, d7, e7, f7, g7, h7, i7, j7],
[a8, b8, c8, d8, e8, f8, g8, h8, i8, j8],
[a9, b9, c9, d9, e9, f9, g9, h9, i9, j9],
[a10, b10, c10, d10, e10, f10, g10, h10, i10, j10]
]