Google Apps Script - introduction - 0 views
code.google.com/...guide_getting_started.html
google script apps Programming javascript tool tools infrastructure
shared by Tiberius Brastaviceanu on 03 May 11
- No Cached
-
installing and running existing scripts from the Script Gallery
-
Spreadsheet
-
Insert
- ...27 more annotations...
-
Install
-
Close
-
Choose a script and click Run
-
The onOpen function adds the Finance menu and the menu item Get Stock to the Spreadsheet
-
the onOpen() function
-
code function onOpen() declares the function and its name
-
code between the curly braces is the code that performs actions when you run the onOpen() function
-
the SpreadsheetApp.getActiveSpreadsheet method to obtain a spreadsheet object representing the currently-active spreadsheet.
-
invoking methods on ss, the script can manipulate the currently-active spreadsheet.
-
method is code that is associate exclusively with a class and performs a particular task on objects of that class
-
insert the column headers into the corresponding cells
-
the getRange() method
-
setValue() method
-
identify
-
arguments
-
You use arguments to pass data to a method.
-
String data
-
is in quotation marks
-
line var row = 2; creates a variable row with an initial value of 2
-
a counter
-
while (true) loop
-
if loop
-
if (!symbol) break; causes the script to exit from the while loop when there is no stock symbol in the variable symbol
-
The exclamation point states a negative (not) condition
-
continues to run, incrementing the row each time until it reaches an empty row
-
the break causes the script to exit from the loop and finish.
-
To comment out the code, put two forward slashes at the beginning of each line:
