Stay organized with collections Save and categorize content based on your preferences.
Detailed documentationgetConcreteColor(themeColorType)
Returns the concrete Color for a valid theme color type. Throws exception if the theme color type is not set in the current theme.
Color — Concrete color.
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/spreadsheetsgetFontFamily()
Returns the font family of the theme, or null if it's a null theme.
String — The theme font family.
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/spreadsheetsgetThemeColors()
Returns a list of all possible theme color types for the current theme.
ReturnThemeColorType[] — A list of theme colors.
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/spreadsheetssetConcreteColor(themeColorType, color)
Sets the concrete color associated with the ThemeColorType in this color scheme to the given color.
themeColorType ThemeColorType The theme color type. color Color The color. Return
SpreadsheetTheme — The theme, 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/spreadsheetssetConcreteColor(themeColorType, red, green, blue)
Sets the concrete color associated with the ThemeColorType in this color scheme to the given color in RGB format.
themeColorType ThemeColorType The theme color type. red Integer The value of red channel. green Integer The value of green channel. blue Integer The value of blue channel. Return
SpreadsheetTheme — The theme, 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/spreadsheetssetFontFamily(fontFamily)
Sets the font family for the theme.
Parameters Name Type DescriptionfontFamily String The new theme font family. Return
SpreadsheetTheme — This theme, 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 `SpreadsheetTheme` object allows you to access and modify existing themes within a spreadsheet."],["You can get and set theme colors using methods like `getConcreteColor`, `setConcreteColor`, and `getThemeColors`."],["The font family of a theme can be retrieved and modified with `getFontFamily` and `setFontFamily`."],["All these methods require authorization with specific scopes, such as `https://www.googleapis.com/auth/spreadsheets`."]]],["Spreadsheet themes can be accessed and modified using `Spreadsheet.setSpreadsheetTheme(theme)`. Key actions include retrieving the concrete color for a theme color type with `getConcreteColor(themeColorType)`, and obtaining the theme's font family using `getFontFamily()`. Users can obtain a list of theme color types with `getThemeColors()`. Themes can be altered by setting the color with `setConcreteColor()`, or setting the font family using `setFontFamily()`. Color settings can be in [Color] or RGB.\n"]]
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