What do you want to save?
Add Code snippet
New code examples
-
Javascript 2022-03-19 01:45:07
google app script column to array indexOf
// Google app script column to array indexOf var numRows = sheet.getLastRow(); var nameRng = sheet.getRange(2, 3, numRows).getValues(); // this is [[v1],[v2],... var nameArr = String(nameRng).split(","); // force column range into a String() ... 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-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 -
TypeScript 2021-10-29 07:04:12
google sheets script save A RANGE to csv
function saveAsCSV() { // Prompts the user for the file name var fileName = Browser.inputBox("Save CSV file as (e.g. myCSVFile):"); // Check that the file name entered wasn't empty if (fileN... Add solution -
Other 2021-10-26 08:37:14
app script comparison existing data
function getNewData() { //deleting triggers var triggers = ScriptApp.getProjectTriggers(); for (var i = 0; i < triggers.length; i++) { if (triggers[i].getHandlerFunction()=='getNewData'){ ScriptApp.deleteTrigger(triggers[i]); } ... 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