Use 1 to specify the first row and 2 to specify the second row, and so on Row Number – 1-based Index of the row.This section demonstrates how to get the range using the row index, the column index, and the getRange() method. Output Get range and Set cell Value Using GetRange() Method And Cell Indexes(Numbers) SpreadsheetApp.getActiveSheet().getRange( 'F2').setValue( 'Hello') Set the value using the setValue() method.Get the range of the Cell F2 using the A1 notation.The R1C1 notation defines a cell with a string that contains the starting and ending cell coordinates using row numbers and column numbers.The A1 notation is the direct reference of the Cell Address- For example, A1 is the first row and column of the sheet.The getRange() method returns the range of the cells as specified using the A1 notation or R1C1 notation. Get range and set cell Value Using GetRange() Method And Cell Address Using GetActiveRange and Set Cell Value.Get Range From Another Spreadsheet and Set Cell Value.Get a Range of Multiple Cells and Set Cell Value.Get range and Set cell Value Using GetRange() Method And Cell Indexes(Numbers).Get range and set cell Value Using GetRange() Method And Cell Address.
