Class DataSourceTableColumn
컬렉션을 사용해 정리하기
내 환경설정을 기준으로 콘텐츠를 저장하고 분류하세요.
자세한 문서
getDataSourceColumn()
데이터 소스 열을 가져옵니다.
리턴
DataSourceColumn: 데이터 소스 열입니다.
승인
이 메서드를 사용하는 스크립트에는 다음 범위 중 하나 이상의 승인이 필요합니다.
-
https://www.googleapis.com/auth/spreadsheets.currentonly
-
https://www.googleapis.com/auth/spreadsheets
remove()
DataSourceTable에서 열을 삭제합니다.
승인
이 메서드를 사용하는 스크립트에는 다음 범위 중 하나 이상의 승인이 필요합니다.
-
https://www.googleapis.com/auth/spreadsheets.currentonly
-
https://www.googleapis.com/auth/spreadsheets
달리 명시되지 않는 한 이 페이지의 콘텐츠에는 Creative Commons Attribution 4.0 라이선스에 따라 라이선스가 부여되며, 코드 샘플에는 Apache 2.0 라이선스에 따라 라이선스가 부여됩니다. 자세한 내용은 Google Developers 사이트 정책을 참조하세요. 자바는 Oracle 및/또는 Oracle 계열사의 등록 상표입니다.
최종 업데이트: 2025-07-26(UTC)
[null,null,["최종 업데이트: 2025-07-26(UTC)"],[[["\u003cp\u003e\u003ccode\u003eDataSourceTableColumn\u003c/code\u003e enables access and modification of existing columns within a \u003ccode\u003eDataSourceTable\u003c/code\u003e linked to a database.\u003c/p\u003e\n"],["\u003cp\u003eUse \u003ccode\u003eDataSourceTable.addColumns(columnNames)\u003c/code\u003e to add new columns to the table, instead of this class.\u003c/p\u003e\n"],["\u003cp\u003eIt provides methods to retrieve the data source column (\u003ccode\u003egetDataSourceColumn()\u003c/code\u003e) and remove it from the table (\u003ccode\u003eremove()\u003c/code\u003e).\u003c/p\u003e\n"],["\u003cp\u003eBoth methods require authorization with specific scopes related to spreadsheet access.\u003c/p\u003e\n"]]],["This class manages existing columns in a DataSourceTable, which is linked to a database. Key actions include retrieving a specific column using `getDataSourceColumn()` and removing a column entirely with `remove()`. Adding new columns is done through `DataSourceTable.addColumns(columnNames)`. The methods require authorization with specific scopes related to spreadsheet access: `https://www.googleapis.com/auth/spreadsheets.currentonly` and `https://www.googleapis.com/auth/spreadsheets`. It is used with data connected to a database.\n"],null,["# Class DataSourceTableColumn\n\nDataSourceTableColumn\n\nAccess and modify an existing column in a [DataSourceTable](/apps-script/reference/spreadsheet/data-source-table). To add columns to a data\nsource table, use [DataSourceTable.addColumns(columnNames)](/apps-script/reference/spreadsheet/data-source-table#addColumns(String)).\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| [getDataSourceColumn()](#getDataSourceColumn()) | [DataSourceColumn](/apps-script/reference/spreadsheet/data-source-column) | Gets the data source column. |\n| [remove()](#remove()) | `void` | Removes the column from the [DataSourceTable](/apps-script/reference/spreadsheet/data-source-table). |\n\nDetailed documentation\n----------------------\n\n### `get``Data``Source``Column()`\n\nGets the data source column.\n\n#### Return\n\n\n[DataSourceColumn](/apps-script/reference/spreadsheet/data-source-column) --- The data source 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### `remove()`\n\nRemoves the column from the [DataSourceTable](/apps-script/reference/spreadsheet/data-source-table).\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`"]]
