SetArray Google

function setarray()
{

var sheetriga=SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Foglio1").getRange("A1:C1");
var sheetcolonna=SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Foglio1").getRange("A1:A3");
var sheetmatrice=SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Foglio1").getRange("A1:C3");
var sheet=SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Foglio1");
var riga=[["a","b","c"]];
var colonna=[["a"],["b"],["c"]];
var matrice=[["a","b","c"],["d","e","f"],["g","h","i"]];


//sheetcolonna.setValues(colonna);
//sheetmatrice.setValues(matrice);
//sheetriga.setValues(riga);

//sheet.appendRow(riga[0]);


}