What do you want to save?
Add Code snippet
New code examples
-
Other 2022-02-19 15:45:26
google apps script to get spreadsheet range to a variable
var sheet = SpreadsheetApp.getActiveSpreadsheet().getSheets()[0]; var range = sheet.getRange('A1:D10'); //range.activate(); var values = range.getValues(); //Logger.log(values[0][0]); var selection = sheet.getSelection(); // Current cell: A1 var currentCe... Add solution -
Javascript 2021-10-09 16:20:03
cell get row google script
var sheet = SpreadsheetApp.getActiveSpreadsheet().getSheets()[0]; var range = sheet.getRange('A1:D10'); //range.activate(); var values = range.getValues(); //Logger.log(values[0][0]); var selection = sheet.getSelection(); // Current cell: A1 var currentCe... Add solution -
Javascript 2021-09-26 20:44:03
javascript get last row googlesheets
//****GLOBALS**** var SpreadsheetID = "1A7Ix7rzrhu7zBKcS7zPeU8w8c_nTae0mBHycvMUE68A"; var SheetName = "CleanData"; function myFunction() { var ss = SpreadsheetApp.openById(SpreadsheetID) var sheet = ss.ge... Add solution -
Go 2021-09-10 16:09:02
read every cell in a column google app script
function appendString() { var range = SpreadsheetApp.getActiveSheet().getActiveRange(); var values = range.getValues(); var modified = values.map(function (row) { return row.map(function (col) { return col + " string"; });... Add solution
Best helpers
+5
+5
+5
+5
+5
+5
+5
+5