Sauf indication contraire, le contenu de cette page est régi par une licence Creative Commons Attribution 4.0, et les échantillons de code sont régis par une licence Apache 2.0. Pour en savoir plus, consultez les Règles du site Google Developers. Java est une marque déposée d'Oracle et/ou de ses sociétés affiliées.
Dernière mise à jour le 2025/07/26 (UTC).
[[["Facile à comprendre","easyToUnderstand","thumb-up"],["J'ai pu résoudre mon problème","solvedMyProblem","thumb-up"],["Autre","otherUp","thumb-up"]],[["Il n'y a pas l'information dont j'ai besoin","missingTheInformationINeed","thumb-down"],["Trop compliqué/Trop d'étapes","tooComplicatedTooManySteps","thumb-down"],["Obsolète","outOfDate","thumb-down"],["Problème de traduction","translationIssue","thumb-down"],["Mauvais exemple/Erreur de code","samplesCodeIssue","thumb-down"],["Autre","otherDown","thumb-down"]],["Dernière mise à jour le 2025/07/26 (UTC)."],[[["\u003cp\u003eThe \u003ccode\u003eDataSourceParameter\u003c/code\u003e class allows access to existing data source parameters, but should only be used with data connected to a database.\u003c/p\u003e\n"],["\u003cp\u003eThis class provides methods to get the parameter name (\u003ccode\u003egetName()\u003c/code\u003e), the source cell (\u003ccode\u003egetSourceCell()\u003c/code\u003e), and the parameter type (\u003ccode\u003egetType()\u003c/code\u003e).\u003c/p\u003e\n"],["\u003cp\u003eIf the parameter type is not \u003ccode\u003eDataSourceParameterType.CELL\u003c/code\u003e, \u003ccode\u003egetSourceCell()\u003c/code\u003e will return \u003ccode\u003enull\u003c/code\u003e.\u003c/p\u003e\n"]]],[],null,["# Class DataSourceParameter\n\nDataSourceParameter\n\nAccess existing data source parameters.\n\n\n**Only use this class with data that's connected to a database.** \n\n### Methods\n\n| Method | Return type | Brief description |\n|-------------------------------------|------------------------------------------------------------------------------------------|---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|\n| [getName()](#getName()) | `String` | Gets the parameter name. |\n| [getSourceCell()](#getSourceCell()) | `String` | Gets the source cell the parameter is valued based on, or `null` if the parameter type is not [DataSourceParameterType.CELL](/apps-script/reference/spreadsheet/data-source-parameter-type#CELL). |\n| [getType()](#getType()) | [DataSourceParameterType](/apps-script/reference/spreadsheet/data-source-parameter-type) | Gets the parameter type. |\n\nDetailed documentation\n----------------------\n\n### `get``Name()`\n\nGets the parameter name.\n\n#### Return\n\n\n`String` --- The parameter name.\n\n*** ** * ** ***\n\n### `get``Source``Cell()`\n\nGets the source cell the parameter is valued based on, or `null` if the parameter type is\nnot [DataSourceParameterType.CELL](/apps-script/reference/spreadsheet/data-source-parameter-type#CELL).\n\n#### Return\n\n\n`String` --- The source cell, as specified in A1 notation.\n\n*** ** * ** ***\n\n### `get``Type()`\n\nGets the parameter type.\n\n#### Return\n\n\n[DataSourceParameterType](/apps-script/reference/spreadsheet/data-source-parameter-type) --- The parameter type."]]