What do you want to save?
Add Code snippet
New code examples
-
Javascript 2022-02-24 12:15:02
google script get current date
Utilities.formatDate(new Date(), "GMT+1", "dd/MM/yyyy") function changeDate() { var sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName(GA_CONFIG); // You could use now Date(); on its own but it will not look nice. ... Add solution -
Javascript 2022-02-21 17:25:17
getValues
let SHEET = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet(); let values = SHEET.getRange(2, 1, SHEET.getLastRow()-1, 1).getValues(); // .getRange(row, column, numRows, numColumns) // So '.getLastRow()-1' because 'values' starts at the second row... Add solution -
Other 2022-02-20 05:25:19
teste google script
function sendEmails() { var ss=SpreadsheetApp.openById("ssid"); var sheet=ss.getSheetByName('**********Your sheet name***********'); var startRow=2; var numRows=2; var dataRange=sheet.getRange(startRow, 1, numRows, 2); //changed to ... Add solution -
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 -
Python 2022-02-01 08:15:05
google sheet python update
from oauth2client.service_account import ServiceAccountCredentials import gspread scope = ['https://spreadsheets.google.com/feeds', 'https://www.googleapis.com/auth/drive', 'https://www.googleapis.com/auth/drive.file', 'https://www.googleapis.co... Add solution
Best helpers
+5
+5
+5
+5
+5
+5
+5
+5
+5
+5
+5
+5
+5
+5
+5
+5
+5
+5
+5
+5
+5