Join Scott Simpson for an in-depth discussion in this video Reading information from a spreadsheet, part of Learning Google Apps Script.
- Adding data to spreadsheets is nice, but it's convenient…to read data form them as well.…Let's clear out most of this code.…I'll delete everything except the openById line.…And let's clear out the spreadsheet as well.…I'll delete this sheet.…And erase my hello.…Then I'll add some data to work with.…A student's first name, last name, and which of two…classes each person is taking.…You can add whatever names you like.…
Back in the IDE let's look at reading…that data into our program.…I'll write var theRange =…ss.getDataRange to get a little…help from the spreadsheet telling me…the range of cells that contain data.…I'll log that so we can take a look at it.…Using a method on the range called GetA1Notation.…
A1Notation is the name for using a letter for the colum…and a number for the row.…If I run the script and open up my logger,…I can see the range that's populated with data.…A1:C5.…Now my data has a header row though and I don't need…that for my program.…So instead of getting the data range, I'll manually…specify a range of cells with a get range…
First, learn how to use simple scripts to edit documents and spreadsheets, work with files in Drive, and find and send messages in Gmail. Then find out how to add custom functionality to your spreadsheets, and build user interface elements for your scripts, using menus, alerts, and dialogs. Finally, Scott shows how to share your work with others by publishing scripts as web apps.
- What is Google Apps Script?
- Understanding script types
- Logging and debugging your scripts
- Scripting common tasks
- Building custom spreadsheet functions
- Creating add-on functionality such as dialogs and sidebars
- Sharing your script as a web app