Google is committed to advancing racial equity for Black communities. See how.

Class SpreadsheetTheme

SpreadsheetTheme

Access and modify existing themes. To set a theme on a spreadsheet, use Spreadsheet.setSpreadsheetTheme(theme).

Methods

MethodReturn typeBrief description
getConcreteColor(themeColorType)ColorReturns the concrete Color for a valid theme color type.
getFontFamily()StringReturns 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)SpreadsheetThemeSets the concrete color associated with the ThemeColorType in this color scheme to the given color.
setConcreteColor(themeColorType, red, green, blue)SpreadsheetThemeSets the concrete color associated with the ThemeColorType in this color scheme to the given color in RGB format.
setFontFamily(fontFamily)SpreadsheetThemeSets 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

NameTypeDescription
themeColorTypeThemeColorTypeTheme 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

NameTypeDescription
themeColorTypeThemeColorTypeThe theme color type.
colorColorThe 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

NameTypeDescription
themeColorTypeThemeColorTypeThe theme color type.
redIntegerThe value of red channel.
greenIntegerThe value of green channel.
blueIntegerThe 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

NameTypeDescription
fontFamilyStringThe 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