Class DeveloperMetadataLocation
Tetap teratur dengan koleksi
Simpan dan kategorikan konten berdasarkan preferensi Anda.
DeveloperMetadataLocation
Mengakses informasi lokasi metadata developer.
Dokumentasi mendetail
getColumn()
Menampilkan Range untuk lokasi kolom metadata ini, atau null jika
jenis lokasi bukan DeveloperMetadataLocationType.COLUMN.
Pulang pergi
Range — Range untuk lokasi kolom metadata ini, atau null jika
jenis lokasi bukan DeveloperMetadataLocationType.COLUMN.
Otorisasi
Skrip yang menggunakan metode ini memerlukan otorisasi dengan satu atau beberapa cakupan berikut:
-
https://www.googleapis.com/auth/spreadsheets.currentonly
-
https://www.googleapis.com/auth/spreadsheets
getLocationType()
Mendapatkan jenis lokasi.
Pulang pergi
DeveloperMetadataLocationType — Jenis lokasi.
Otorisasi
Skrip yang menggunakan metode ini memerlukan otorisasi dengan satu atau beberapa cakupan berikut:
-
https://www.googleapis.com/auth/spreadsheets.currentonly
-
https://www.googleapis.com/auth/spreadsheets
getRow()
Menampilkan Range untuk lokasi baris metadata ini, atau null jika
jenis lokasi bukan DeveloperMetadataLocationType.ROW.
Pulang pergi
Range — Range untuk lokasi baris metadata ini, atau null jika
jenis lokasi bukan DeveloperMetadataLocationType.ROW.
Otorisasi
Skrip yang menggunakan metode ini memerlukan otorisasi dengan satu atau beberapa cakupan berikut:
-
https://www.googleapis.com/auth/spreadsheets.currentonly
-
https://www.googleapis.com/auth/spreadsheets
getSheet()
Menampilkan lokasi Sheet metadata ini, atau null jika jenis lokasi
bukan DeveloperMetadataLocationType.SHEET.
Pulang pergi
Sheet — Lokasi Sheet metadata ini, atau null jika jenis lokasinya
bukan DeveloperMetadataLocationType.SHEET.
Otorisasi
Skrip yang menggunakan metode ini memerlukan otorisasi dengan satu atau beberapa cakupan berikut:
-
https://www.googleapis.com/auth/spreadsheets.currentonly
-
https://www.googleapis.com/auth/spreadsheets
getSpreadsheet()
Menampilkan lokasi Spreadsheet metadata ini, atau null jika jenis lokasi
bukan DeveloperMetadataLocationType.SPREADSHEET.
Pulang pergi
Spreadsheet — Lokasi Spreadsheet metadata ini, atau null jika jenis lokasinya bukan DeveloperMetadataLocationType.SPREADSHEET.
Otorisasi
Skrip yang menggunakan metode ini memerlukan otorisasi dengan satu atau beberapa cakupan berikut:
-
https://www.googleapis.com/auth/spreadsheets.currentonly
-
https://www.googleapis.com/auth/spreadsheets
Kecuali dinyatakan lain, konten di halaman ini dilisensikan berdasarkan Lisensi Creative Commons Attribution 4.0, sedangkan contoh kode dilisensikan berdasarkan Lisensi Apache 2.0. Untuk mengetahui informasi selengkapnya, lihat Kebijakan Situs Google Developers. Java adalah merek dagang terdaftar dari Oracle dan/atau afiliasinya.
Terakhir diperbarui pada 2025-07-26 UTC.
[null,null,["Terakhir diperbarui pada 2025-07-26 UTC."],[[["\u003cp\u003e\u003ccode\u003eDeveloperMetadataLocation\u003c/code\u003e provides access to information about the location of developer metadata within a spreadsheet.\u003c/p\u003e\n"],["\u003cp\u003eIt offers methods to retrieve the location type, which can be a spreadsheet, sheet, row, or column.\u003c/p\u003e\n"],["\u003cp\u003eYou can get the specific Spreadsheet, Sheet, or Range associated with the metadata, depending on its location type.\u003c/p\u003e\n"],["\u003cp\u003eAll methods require authorization with either \u003ccode\u003ehttps://www.googleapis.com/auth/spreadsheets.currentonly\u003c/code\u003e or \u003ccode\u003ehttps://www.googleapis.com/auth/spreadsheets\u003c/code\u003e scopes.\u003c/p\u003e\n"]]],[],null,["# Class DeveloperMetadataLocation\n\nDeveloperMetadataLocation\n\nAccess developer metadata location information. \n\n### Methods\n\n| Method | Return type | Brief description |\n|-----------------------------------------|------------------------------------------------------------------------------------------------------|-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|\n| [getColumn()](#getColumn()) | [Range](/apps-script/reference/spreadsheet/range) | Returns the [Range](/apps-script/reference/spreadsheet/range) for the column location of this metadata, or `null` if the location type is not `Developer``Metadata``Location``Type.COLUMN`. |\n| [getLocationType()](#getLocationType()) | [DeveloperMetadataLocationType](/apps-script/reference/spreadsheet/developer-metadata-location-type) | Gets the type of location. |\n| [getRow()](#getRow()) | [Range](/apps-script/reference/spreadsheet/range) | Returns the [Range](/apps-script/reference/spreadsheet/range) for the row location of this metadata, or `null` if the location type is not `Developer``Metadata``Location``Type.ROW`. |\n| [getSheet()](#getSheet()) | [Sheet](/apps-script/reference/spreadsheet/sheet) | Returns the [Sheet](/apps-script/reference/spreadsheet/sheet) location of this metadata, or `null` if the location type is not `Developer``Metadata``Location``Type.SHEET`. |\n| [getSpreadsheet()](#getSpreadsheet()) | [Spreadsheet](/apps-script/reference/spreadsheet/spreadsheet) | Returns the [Spreadsheet](/apps-script/reference/spreadsheet/spreadsheet) location of this metadata, or `null` if the location type is not `Developer``Metadata``Location``Type.SPREADSHEET`. |\n\nDetailed documentation\n----------------------\n\n### `get``Column()`\n\nReturns the [Range](/apps-script/reference/spreadsheet/range) for the column location of this metadata, or `null` if the\nlocation type is not `Developer``Metadata``Location``Type.COLUMN`.\n\n#### Return\n\n\n[Range](/apps-script/reference/spreadsheet/range) --- The [Range](/apps-script/reference/spreadsheet/range) for the column location of this metadata, or `null` if the\nlocation type is not `Developer``Metadata``Location``Type.COLUMN`.\n\n#### Authorization\n\nScripts that use this method require authorization with one or more of the following [scopes](/apps-script/concepts/scopes#setting_explicit_scopes):\n\n- `https://www.googleapis.com/auth/spreadsheets.currentonly`\n- `https://www.googleapis.com/auth/spreadsheets`\n\n*** ** * ** ***\n\n### `get``Location``Type()`\n\nGets the type of location.\n\n#### Return\n\n\n[DeveloperMetadataLocationType](/apps-script/reference/spreadsheet/developer-metadata-location-type) --- The location type.\n\n#### Authorization\n\nScripts that use this method require authorization with one or more of the following [scopes](/apps-script/concepts/scopes#setting_explicit_scopes):\n\n- `https://www.googleapis.com/auth/spreadsheets.currentonly`\n- `https://www.googleapis.com/auth/spreadsheets`\n\n*** ** * ** ***\n\n### `get``Row()`\n\nReturns the [Range](/apps-script/reference/spreadsheet/range) for the row location of this metadata, or `null` if the\nlocation type is not `Developer``Metadata``Location``Type.ROW`.\n\n#### Return\n\n\n[Range](/apps-script/reference/spreadsheet/range) --- The [Range](/apps-script/reference/spreadsheet/range) for the row location of this metadata, or `null` if the\nlocation type is not `Developer``Metadata``Location``Type.ROW`.\n\n#### Authorization\n\nScripts that use this method require authorization with one or more of the following [scopes](/apps-script/concepts/scopes#setting_explicit_scopes):\n\n- `https://www.googleapis.com/auth/spreadsheets.currentonly`\n- `https://www.googleapis.com/auth/spreadsheets`\n\n*** ** * ** ***\n\n### `get``Sheet()`\n\nReturns the [Sheet](/apps-script/reference/spreadsheet/sheet) location of this metadata, or `null` if the location type is\nnot `Developer``Metadata``Location``Type.SHEET`.\n\n#### Return\n\n\n[Sheet](/apps-script/reference/spreadsheet/sheet) --- The [Sheet](/apps-script/reference/spreadsheet/sheet) location of this metadata, or `null` if the location type is\nnot `Developer``Metadata``Location``Type.SHEET`.\n\n#### Authorization\n\nScripts that use this method require authorization with one or more of the following [scopes](/apps-script/concepts/scopes#setting_explicit_scopes):\n\n- `https://www.googleapis.com/auth/spreadsheets.currentonly`\n- `https://www.googleapis.com/auth/spreadsheets`\n\n*** ** * ** ***\n\n### `get``Spreadsheet()`\n\nReturns the [Spreadsheet](/apps-script/reference/spreadsheet/spreadsheet) location of this metadata, or `null` if the location\ntype is not `Developer``Metadata``Location``Type.SPREADSHEET`.\n\n#### Return\n\n\n[Spreadsheet](/apps-script/reference/spreadsheet/spreadsheet) --- The [Spreadsheet](/apps-script/reference/spreadsheet/spreadsheet) location of this metadata, or `null` if the location\ntype is not `Developer``Metadata``Location``Type.SPREADSHEET`.\n\n#### Authorization\n\nScripts that use this method require authorization with one or more of the following [scopes](/apps-script/concepts/scopes#setting_explicit_scopes):\n\n- `https://www.googleapis.com/auth/spreadsheets.currentonly`\n- `https://www.googleapis.com/auth/spreadsheets`"]]
