com.google.appsscript.spreadsheet
SpreadsheetApp
Related Docs:
trait SpreadsheetApp
| package spreadsheet
com.google.appsscript.spreadsheet
Creates a new spreadsheet with the given name and the specified number of rows and columns.
Creates a new spreadsheet with the given name and the specified number of rows and columns.
Creates a new spreadsheet with the given name.
Creates a new spreadsheet with the given name.
Applies all pending Spreadsheet changes.
Applies all pending Spreadsheet changes. Spreadsheet operations are sometimes bundled together to improve performance, such as when doing multiple calls to Range.getValue(). However, sometimes you may want to make sure that all pending changes are made right away, for instance to show users data as a script is executing.
Returns the currently active spreadsheet, or null if there is none.
Returns the currently active spreadsheet, or null if there is none. Functions that are run in the context of a spreadsheet can get a reference to the corresponding Spreadsheet object by calling this function.
Returns the range of cells that is currently considered active.
Returns the range of cells that is currently considered active. This generally means the range that a user has selected in the active sheet, but in a custom function it refers to the cell being actively recalculated.
Gets the active sheet in a spreadsheet.
Gets the active sheet in a spreadsheet. The active sheet in a spreadsheet is the sheet that is being displayed in the spreadsheet UI.
Returns the currently active spreadsheet, or null if there is none.
Returns the currently active spreadsheet, or null if there is none. Functions that are run in the context of a spreadsheet can get a reference to the corresponding Spreadsheet object by calling this function.
Returns an instance of the spreadsheet's user-interface environment that allows the script to add features like menus, dialogs, and sidebars.
Returns an instance of the spreadsheet's user-interface environment that allows the script to add features like menus, dialogs, and sidebars. A script can only interact with the UI for the current instance of an open spreadsheet, and only if the script is bound to the spreadsheet. For more information, see the guides to menus and dialogs and sidebars.
Creates a builder for a data-validation rule.
Creates a builder for a data-validation rule.
Opens the spreadsheet that corresponds to the given File object.
Opens the spreadsheet that corresponds to the given File object.
Opens the spreadsheet with the given ID.
Opens the spreadsheet with the given ID. A spreadsheet ID can be extracted from its URL. For example, the spreadsheet ID in the URL https://docs.google.com/spreadsheets/d/abc1234567/edit#gid=0 is "abc1234567".
Opens the spreadsheet with the given url.
Opens the spreadsheet with the given url.
Sets the active range for the application.
Sets the active range for the application. The spreadsheet UI will display the sheet that contains the chosen range and will select the cells defined in the chosen range.
Sets the active sheet in a spreadsheet.
Sets the active sheet in a spreadsheet. The spreadsheet UI will display the chosen sheet unless the sheet belongs to a different spreadsheet.
Sets the active spreadsheet.
Sets the active spreadsheet.
Entry point for the Spreadsheet API