Class SpreadsheetTheme

SpreadsheetTheme

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