This ID number is randomized, but you can also see it in the spreadsheet URL in the format:
The ID is present in the URL of the spreadsheet in the format:Įach sheet in a spreadsheet also has an ID number unique to that spreadsheet. Key Point: In addition to a name, spreadsheets also have an ID string unique to that sheet. You can use the Sheet** class to access and modify sheet-level data and settings, such as moving rows or columns of data. You can also use this class for other file-level operations, such as adding collaborators.Ī sheet** represents the individual page of a spreadsheet, sometimes referred to as a "tab." Each spreadsheet can contain one or more sheets. You can use the Spreadsheet class to access and modify Google Sheets file data. A spreadsheet is sometimes referred to as a ‘Google Sheet', in the same way that a document is referred to as a ‘Google Doc'. Spreadsheets, sheets, and their classesĪs a Sheets term, a spreadsheet is a Google Sheets file (stored in Google Drive) that contains data organized by rows and columns. However, later in this codelab you can find both examples and exercises to help you understand this class. The SpreadsheetApp class is not explored in depth here. You can think of SpreadsheetApp as the main class of the Spreadsheet service. Many scripts begin by calling SpreadsheetApp methods, as they can provide the initial point of access to your Google Sheets files. The SpreadsheetApp Classīefore delving into spreadsheets, sheets, and ranges, you should review their parent class: SpreadsheetApp. This section describes these classes and what they're used for. Introduction to the Spreadsheet serviceįour classes encompass the foundation of the Spreadsheet service: SpreadsheetApp, Spreadsheet, Sheet, and Range. The next section introduces the core classes of the Spreadsheet service.Ģ.
#SPECIFIC GOOGLE SHEET UNRESPONSIVE SCRIPT FIREFOX HOW TO#
How to specify, activate, move, and sort a group of cells or range of data using the Range class.How to change a sheet's name and a range's column/row orientation, using the Sheet class.
How to access, create, and rename the active (open) spreadsheet with the SpreadsheetApp and Spreadsheet class.How spreadsheets, sheets, and ranges are represented in Apps Script.This codelab delves into the Spreadsheet service that you can use to read, write, and manipulate data in Google Sheets. The previous codelab focused on the concepts of the script editor, macros, and custom functions. Welcome to the second part of the Fundamentals of Apps Script with Google Sheets codelab playlist.