google apps scipt getvalues code example

Example 1: setValue()

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

Example 2: set cell value google script

function doTest() {
  SpreadsheetApp.getActiveSheet().getRange('F2').setValue('Hello');
}

Example 3: set cell value google script

function storeValue() {
  var ss = SpreadsheetApp.getActiveSpreadsheet();
  // ss is now the spreadsheet the script is associated with
  var sheet = ss.getSheets()[0]; // sheets are counted starting from 0
  // sheet is the first worksheet in the spreadsheet
  var cell = sheet.getRange("B2"); 
  cell.setValue(100);
}

Example 4: google apps scipt getRange

getRange(row, column, numRows, numColumns)