Stay organized with collections Save and categorize content based on your preferences.
DataSourceColumnAccess and modify a data source column.
Only use this class with data that's connected to a database.
Detailed documentationgetDataSource()
Gets the data source associated with the data source column.
ReturnDataSource — The data source.
Scripts that use this method require authorization with one or more of the following scopes:
https://www.googleapis.com/auth/spreadsheets.currentonlyhttps://www.googleapis.com/auth/spreadsheetsgetFormula()
Gets the formula for the data source column. Returns an empty string if the data source column is not a calculated column.
String — The formula.
Scripts that use this method require authorization with one or more of the following scopes:
https://www.googleapis.com/auth/spreadsheets.currentonlyhttps://www.googleapis.com/auth/spreadsheetsgetName()
Gets the name for the data source column.
ReturnString — The column name.
Scripts that use this method require authorization with one or more of the following scopes:
https://www.googleapis.com/auth/spreadsheets.currentonlyhttps://www.googleapis.com/auth/spreadsheetshasArrayDependency()
Returns whether the column has an array dependency.
ReturnBoolean — true if the column has an array dependency, or false otherwise.
Scripts that use this method require authorization with one or more of the following scopes:
https://www.googleapis.com/auth/spreadsheets.currentonlyhttps://www.googleapis.com/auth/spreadsheetsisCalculatedColumn()
Returns whether the column is a calculated column.
ReturnBoolean — true if the column is a calculated column, or false otherwise.
Scripts that use this method require authorization with one or more of the following scopes:
https://www.googleapis.com/auth/spreadsheets.currentonlyhttps://www.googleapis.com/auth/spreadsheetsremove()
Removes the data source column.
Only supported for calculated columns.
Scripts that use this method require authorization with one or more of the following scopes:
https://www.googleapis.com/auth/spreadsheets.currentonlyhttps://www.googleapis.com/auth/spreadsheetssetFormula(formula)
Sets the formula for the data source column.
Only supported for calculated columns.
formula String The new formula. Return
DataSourceColumn — The data source column, for chaining.
Scripts that use this method require authorization with one or more of the following scopes:
https://www.googleapis.com/auth/spreadsheets.currentonlyhttps://www.googleapis.com/auth/spreadsheetssetName(name)
Sets the name of the data source column.
Only supported for calculated columns.
name String The name to set. Return
DataSourceColumn — The data source column, for chaining.
Scripts that use this method require authorization with one or more of the following scopes:
https://www.googleapis.com/auth/spreadsheets.currentonlyhttps://www.googleapis.com/auth/spreadsheetsExcept as otherwise noted, the content of this page is licensed under the Creative Commons Attribution 4.0 License, and code samples are licensed under the Apache 2.0 License. For details, see the Google Developers Site Policies. Java is a registered trademark of Oracle and/or its affiliates.
Last updated 2024-12-02 UTC.
[[["Easy to understand","easyToUnderstand","thumb-up"],["Solved my problem","solvedMyProblem","thumb-up"],["Other","otherUp","thumb-up"]],[["Missing the information I need","missingTheInformationINeed","thumb-down"],["Too complicated / too many steps","tooComplicatedTooManySteps","thumb-down"],["Out of date","outOfDate","thumb-down"],["Samples / code issue","samplesCodeIssue","thumb-down"],["Other","otherDown","thumb-down"]],["Last updated 2024-12-02 UTC."],[[["The `DataSourceColumn` class allows you to programmatically access and modify data source columns connected to a database in Google Sheets."],["You can get and set the formula and name for calculated columns, as well as get the associated data source and check for array dependencies."],["This class provides methods for checking if a column is calculated or has array dependencies, along with the ability to remove calculated columns."],["All methods within the `DataSourceColumn` class require authorization with specific Google Sheets scopes."]]],[]]
RetroSearch is an open source project built by @garambo | Open a GitHub Issue
Search and Browse the WWW like it's 1997 | Search results from DuckDuckGo
HTML:
3.2
| Encoding:
UTF-8
| Version:
0.7.4