Access developer metadata location information.
Methods
| Method | Return type | Brief description |
|---|---|---|
getColumn() | Range | Returns the Range for the column location of this metadata, or null if the
location type is not DeveloperMetadataLocationType.COLUMN. |
getLocationType() | DeveloperMetadataLocationType | Gets the type of location. |
getRow() | Range | Returns the Range for the row location of this metadata, or null if the
location type is not DeveloperMetadataLocationType.ROW. |
getSheet() | Sheet | Returns the Sheet location of this metadata, or null if the location type is
not DeveloperMetadataLocationType.SHEET. |
getSpreadsheet() | Spreadsheet | Returns the Spreadsheet location of this metadata, or null if the location
type is not DeveloperMetadataLocationType.SPREADSHEET. |
Detailed documentation
getColumn()
Returns the Range for the column location of this metadata, or null if the
location type is not DeveloperMetadataLocationType.COLUMN.
Return
Range — The Range for the column location of this metadata, or null if the
location type is not DeveloperMetadataLocationType.COLUMN.
Authorization
Scripts that use this method require authorization with one or more of the following scopes:
-
https://www.googleapis.com/auth/spreadsheets.currentonly -
https://www.googleapis.com/auth/spreadsheets
getLocationType()
Gets the type of location.
Return
DeveloperMetadataLocationType — The location type.
Authorization
Scripts that use this method require authorization with one or more of the following scopes:
-
https://www.googleapis.com/auth/spreadsheets.currentonly -
https://www.googleapis.com/auth/spreadsheets
getRow()
Returns the Range for the row location of this metadata, or null if the
location type is not DeveloperMetadataLocationType.ROW.
Return
Range — The Range for the row location of this metadata, or null if the
location type is not DeveloperMetadataLocationType.ROW.
Authorization
Scripts that use this method require authorization with one or more of the following scopes:
-
https://www.googleapis.com/auth/spreadsheets.currentonly -
https://www.googleapis.com/auth/spreadsheets
getSheet()
Returns the Sheet location of this metadata, or null if the location type is
not DeveloperMetadataLocationType.SHEET.
Return
Sheet — The Sheet location of this metadata, or null if the location type is
not DeveloperMetadataLocationType.SHEET.
Authorization
Scripts that use this method require authorization with one or more of the following scopes:
-
https://www.googleapis.com/auth/spreadsheets.currentonly -
https://www.googleapis.com/auth/spreadsheets
getSpreadsheet()
Returns the Spreadsheet location of this metadata, or null if the location
type is not DeveloperMetadataLocationType.SPREADSHEET.
Return
Spreadsheet — The Spreadsheet location of this metadata, or null if the location
type is not DeveloperMetadataLocationType.SPREADSHEET.
Authorization
Scripts that use this method require authorization with one or more of the following scopes:
-
https://www.googleapis.com/auth/spreadsheets.currentonly -
https://www.googleapis.com/auth/spreadsheets