Last active
November 14, 2015 07:02
-
-
Save mpmckenna8/b523696eb11143584d68 to your computer and use it in GitHub Desktop.
To insert the countries with a script rather than as keybordists
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
function myFunction() { | |
// Made the countries into an array | |
var countries = ["Brazil", "Chile", "Colombia", "Uruguay", "France", | |
"Nigeria", "Germany", "Algeria", "Netherlands", "Mexico", "Costa Rica", | |
"Greece", "Argentina", "Switzerland", "Belgium", "United States"]; | |
// grabbing the spreadsheed we're working with and naming it ss | |
var ss = SpreadsheetApp.getActiveSpreadsheet(); | |
var SHEET_TEAMS = 'Teams'; | |
var sheetControl = ss.getSheetByName(SHEET_TEAMS); | |
Logger.log(rangeTeams); | |
for(i in countries){ | |
// cell = ranger.getCell(i+1 , 1); | |
// each column in the row is an array element, we just need one here and it's the country | |
sheetControl.appendRow([countries[i]]); | |
} | |
} |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment