Class DataSourceTableColumn

  • DataSourceTableColumn enables access and modification of existing columns within a DataSourceTable linked to a database.

  • Use DataSourceTable.addColumns(columnNames) to add new columns to the table, instead of this class.

  • It provides methods to retrieve the data source column (getDataSourceColumn()) and remove it from the table (remove()).

  • Both methods require authorization with specific scopes related to spreadsheet access.

DataSourceTableColumn

Access and modify an existing column in a DataSourceTable. To add columns to a data source table, use DataSourceTable.addColumns(columnNames).

Only use this class with data that's connected to a database.

Methods

MethodReturn typeBrief description
getDataSourceColumn()DataSourceColumnGets the data source column.
remove()voidRemoves the column from the DataSourceTable.

Detailed documentation

getDataSourceColumn()

Gets the data source column.

Return

DataSourceColumn — The data source 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

remove()

Removes the column from the DataSourceTable.

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