Class DeveloperMetadataLocation

AI-generated Key Takeaways

• DeveloperMetadataLocation provides access to information about the location of developer metadata within a spreadsheet.

• It offers methods to retrieve the location type, which can be a spreadsheet, sheet, row, or column.

• You can get the specific Spreadsheet, Sheet, or Range associated with the metadata, depending on its location type.

• All methods require authorization with either https://www.googleapis.com/auth/spreadsheets.currentonly or https://www.googleapis.com/auth/spreadsheets scopes.

DeveloperMetadataLocation

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