Access and modify existing themes. To set a theme on a spreadsheet, use Spreadsheet.setSpreadsheetTheme(theme)
.
Methods
Method | Return type | Brief description |
---|---|---|
getConcreteColor(themeColorType) | Color | Returns the concrete Color for a valid theme color type. |
getFontFamily() | String | Returns the font family of the theme, or null if it's a null theme. |
getThemeColors() | ThemeColorType[] | Returns a list of all possible theme color types for the current theme. |
setConcreteColor(themeColorType, color) | SpreadsheetTheme | Sets the concrete color associated with the ThemeColorType in this color scheme to the
given color. |
setConcreteColor(themeColorType, red, green, blue) | SpreadsheetTheme | Sets the concrete color associated with the ThemeColorType in this color scheme to the
given color in RGB format. |
setFontFamily(fontFamily) | SpreadsheetTheme | Sets the font family for the theme. |
Detailed documentation
getConcreteColor(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.
Parameters
Name | Type | Description |
---|---|---|
themeColorType | ThemeColorType | Theme color type. |
Return
Color
— Concrete color.
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
getFontFamily()
Returns the font family of the theme, or null
if it's a null
theme.
Return
String
— The theme font family.
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
getThemeColors()
Returns a list of all possible theme color types for the current theme.
Return
ThemeColorType[]
— A list of theme colors.
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
setConcreteColor(themeColorType, color)
Sets the concrete color associated with the ThemeColorType
in this color scheme to the
given color.
Parameters
Name | Type | Description |
---|---|---|
themeColorType | ThemeColorType | The theme color type. |
color | Color | The color. |
Return
SpreadsheetTheme
— The theme, for chaining.
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
setConcreteColor(themeColorType, red, green, blue)
Sets the concrete color associated with the ThemeColorType
in this color scheme to the
given color in RGB format.
Parameters
Name | Type | Description |
---|---|---|
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.
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
setFontFamily(fontFamily)
Sets the font family for the theme.
Parameters
Name | Type | Description |
---|---|---|
fontFamily | String | The new theme font family. |
Return
SpreadsheetTheme
— This theme, for chaining.
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