setvalues 28 29

1SpreadsheetApp.getActive().getRange("A1").setValue('abc');

1var ss = SpreadsheetApp.getActiveSpreadsheet();
2var sheet = ss.getSheets()[0];
3
4// The size of the two-dimensional array must match the size of the range.
5var values = [
6  [ "2.000", "1,000,000", "$2.99" ]
7];
8
9var range = sheet.getRange("A1:C1");
10range.setValues(values);

1let SHEET = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
2  
3let values = SHEET.getRange(2, 1, SHEET.getLastRow()-1, 1).getValues();
4// .getRange(row, column, numRows, numColumns)
5// So '.getLastRow()-1' because 'values' starts at the second row
6  
7let valuesDestination = SHEET.getRange(`B2:B${SHEET.getLastRow()}`)
8  
9valuesDestination.setValues(values);