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