DeveloperMetadataLocation

Access developer metadata location information.

### Methods

| Method | Return type | Brief description |
|---|---|---|
| `https://developers.google.com/apps-script/reference/spreadsheet/developer-metadata-location#getColumn()` | `https://developers.google.com/apps-script/reference/spreadsheet/range|null` | Returns the `https://developers.google.com/apps-script/reference/spreadsheet/range` for the column location of this metadata, or `null` if the location type is not `DeveloperMetadataLocationType.COLUMN`. |
| `https://developers.google.com/apps-script/reference/spreadsheet/developer-metadata-location#getLocationType()` | `https://developers.google.com/apps-script/reference/spreadsheet/developer-metadata-location-type` | Gets the type of location. |
| `https://developers.google.com/apps-script/reference/spreadsheet/developer-metadata-location#getRow()` | `https://developers.google.com/apps-script/reference/spreadsheet/range|null` | Returns the `https://developers.google.com/apps-script/reference/spreadsheet/range` for the row location of this metadata, or `null` if the location type is not `DeveloperMetadataLocationType.ROW`. |
| `https://developers.google.com/apps-script/reference/spreadsheet/developer-metadata-location#getSheet()` | `https://developers.google.com/apps-script/reference/spreadsheet/sheet|null` | Returns the `https://developers.google.com/apps-script/reference/spreadsheet/sheet` location of this metadata, or `null` if the location type is not `DeveloperMetadataLocationType.SHEET`. |
| `https://developers.google.com/apps-script/reference/spreadsheet/developer-metadata-location#getSpreadsheet()` | `https://developers.google.com/apps-script/reference/spreadsheet/spreadsheet|null` | Returns the `https://developers.google.com/apps-script/reference/spreadsheet/spreadsheet` location of this metadata, or `null` if the location type is not `DeveloperMetadataLocationType.SPREADSHEET`. |

## Detailed documentation

### `getColumn()`

Returns the `https://developers.google.com/apps-script/reference/spreadsheet/range` for the column location of this metadata, or `null` if the
location type is not `DeveloperMetadataLocationType.COLUMN`.

#### Return


`https://developers.google.com/apps-script/reference/spreadsheet/range|null` --- The `https://developers.google.com/apps-script/reference/spreadsheet/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://developers.google.com/apps-script/concepts/scopes#setting_explicit_scopes):

- `https://www.googleapis.com/auth/spreadsheets.currentonly`
- `https://www.googleapis.com/auth/spreadsheets`

*** ** * ** ***

### `getLocationType()`

Gets the type of location.

#### Return


`https://developers.google.com/apps-script/reference/spreadsheet/developer-metadata-location-type` --- The location type.

#### Authorization

Scripts that use this method require authorization with one or more of the following [scopes](https://developers.google.com/apps-script/concepts/scopes#setting_explicit_scopes):

- `https://www.googleapis.com/auth/spreadsheets.currentonly`
- `https://www.googleapis.com/auth/spreadsheets`

*** ** * ** ***

### `getRow()`

Returns the `https://developers.google.com/apps-script/reference/spreadsheet/range` for the row location of this metadata, or `null` if the
location type is not `DeveloperMetadataLocationType.ROW`.

#### Return


`https://developers.google.com/apps-script/reference/spreadsheet/range|null` --- The `https://developers.google.com/apps-script/reference/spreadsheet/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://developers.google.com/apps-script/concepts/scopes#setting_explicit_scopes):

- `https://www.googleapis.com/auth/spreadsheets.currentonly`
- `https://www.googleapis.com/auth/spreadsheets`

*** ** * ** ***

### `getSheet()`

Returns the `https://developers.google.com/apps-script/reference/spreadsheet/sheet` location of this metadata, or `null` if the location type is
not `DeveloperMetadataLocationType.SHEET`.

#### Return


`https://developers.google.com/apps-script/reference/spreadsheet/sheet|null` --- The `https://developers.google.com/apps-script/reference/spreadsheet/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://developers.google.com/apps-script/concepts/scopes#setting_explicit_scopes):

- `https://www.googleapis.com/auth/spreadsheets.currentonly`
- `https://www.googleapis.com/auth/spreadsheets`

*** ** * ** ***

### `getSpreadsheet()`

Returns the `https://developers.google.com/apps-script/reference/spreadsheet/spreadsheet` location of this metadata, or `null` if the location
type is not `DeveloperMetadataLocationType.SPREADSHEET`.

#### Return


`https://developers.google.com/apps-script/reference/spreadsheet/spreadsheet|null` --- The `https://developers.google.com/apps-script/reference/spreadsheet/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://developers.google.com/apps-script/concepts/scopes#setting_explicit_scopes):

- `https://www.googleapis.com/auth/spreadsheets.currentonly`
- `https://www.googleapis.com/auth/spreadsheets`