Q:

google script range get cell values

var values = [
  ["2.000", "1,000,000", "$2.99"]
];

var range = sheet.getRange("B2:D2");
range.setValues(values);
0
var myCell = myRange.getCell(row, column)	//Returns a given cell within a range.
0
function doTest() {
  SpreadsheetApp.getActiveSheet().getRange('F2').setValue('Hello');
}
0

New to Communities?

Join the community