Class SpreadsheetTheme
컬렉션을 사용해 정리하기
내 환경설정을 기준으로 콘텐츠를 저장하고 분류하세요.
자세한 문서
getConcreteColor(themeColorType)
유효한 테마 색상 유형의 구체적인 Color를 반환합니다. 현재 테마에서 테마 색상 유형이 설정되지 않은 경우 예외를 발생시킵니다.
매개변수
리턴
Color: 콘크리트 색상입니다.
승인
이 메서드를 사용하는 스크립트에는 다음 범위 중 하나 이상의 승인이 필요합니다.
-
https://www.googleapis.com/auth/spreadsheets.currentonly
-
https://www.googleapis.com/auth/spreadsheets
getFontFamily()
테마의 글꼴 모음을 반환하거나 null 테마인 경우 null을 반환합니다.
리턴
String: 테마 글꼴 모음입니다.
승인
이 메서드를 사용하는 스크립트에는 다음 범위 중 하나 이상의 승인이 필요합니다.
-
https://www.googleapis.com/auth/spreadsheets.currentonly
-
https://www.googleapis.com/auth/spreadsheets
getThemeColors()
현재 테마에 가능한 모든 테마 색상 유형 목록을 반환합니다.
리턴
ThemeColorType[] — 테마 색상 목록입니다.
승인
이 메서드를 사용하는 스크립트에는 다음 범위 중 하나 이상의 승인이 필요합니다.
-
https://www.googleapis.com/auth/spreadsheets.currentonly
-
https://www.googleapis.com/auth/spreadsheets
setConcreteColor(themeColorType, color)
이 색 구성표에서 ThemeColorType와 연결된 구체적인 색상을 지정된 색상으로 설정합니다.
매개변수
리턴
SpreadsheetTheme: 체이닝을 위한 테마입니다.
승인
이 메서드를 사용하는 스크립트에는 다음 범위 중 하나 이상의 승인이 필요합니다.
-
https://www.googleapis.com/auth/spreadsheets.currentonly
-
https://www.googleapis.com/auth/spreadsheets
setConcreteColor(themeColorType, red, green, blue)
이 색 구성표에서 ThemeColorType와 연결된 구체적인 색상을 RGB 형식의 지정된 색상으로 설정합니다.
매개변수
| 이름 | 유형 | 설명 |
themeColorType | ThemeColorType | 테마 색상 유형입니다. |
red | Integer | 빨간색 채널의 값입니다. |
green | Integer | 녹색 채널의 값입니다. |
blue | Integer | 파란색 채널의 값입니다. |
리턴
SpreadsheetTheme: 체이닝을 위한 테마입니다.
승인
이 메서드를 사용하는 스크립트에는 다음 범위 중 하나 이상의 승인이 필요합니다.
-
https://www.googleapis.com/auth/spreadsheets.currentonly
-
https://www.googleapis.com/auth/spreadsheets
setFontFamily(fontFamily)
테마의 글꼴 모음을 설정합니다.
매개변수
| 이름 | 유형 | 설명 |
fontFamily | String | 새 테마 글꼴 모음 |
리턴
SpreadsheetTheme: 체이닝을 위한 이 테마입니다.
승인
이 메서드를 사용하는 스크립트에는 다음 범위 중 하나 이상의 승인이 필요합니다.
-
https://www.googleapis.com/auth/spreadsheets.currentonly
-
https://www.googleapis.com/auth/spreadsheets
달리 명시되지 않는 한 이 페이지의 콘텐츠에는 Creative Commons Attribution 4.0 라이선스에 따라 라이선스가 부여되며, 코드 샘플에는 Apache 2.0 라이선스에 따라 라이선스가 부여됩니다. 자세한 내용은 Google Developers 사이트 정책을 참조하세요. 자바는 Oracle 및/또는 Oracle 계열사의 등록 상표입니다.
최종 업데이트: 2025-07-26(UTC)
[null,null,["최종 업데이트: 2025-07-26(UTC)"],[[["\u003cp\u003eThe \u003ccode\u003eSpreadsheetTheme\u003c/code\u003e object allows you to access and modify existing themes within a spreadsheet.\u003c/p\u003e\n"],["\u003cp\u003eYou can get and set theme colors using methods like \u003ccode\u003egetConcreteColor\u003c/code\u003e, \u003ccode\u003esetConcreteColor\u003c/code\u003e, and \u003ccode\u003egetThemeColors\u003c/code\u003e.\u003c/p\u003e\n"],["\u003cp\u003eThe font family of a theme can be retrieved and modified with \u003ccode\u003egetFontFamily\u003c/code\u003e and \u003ccode\u003esetFontFamily\u003c/code\u003e.\u003c/p\u003e\n"],["\u003cp\u003eAll these methods require authorization with specific scopes, such as \u003ccode\u003ehttps://www.googleapis.com/auth/spreadsheets\u003c/code\u003e.\u003c/p\u003e\n"]]],["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"],null,["# Class SpreadsheetTheme\n\nSpreadsheetTheme\n\nAccess and modify existing themes. To set a theme on a spreadsheet, use [Spreadsheet.setSpreadsheetTheme(theme)](/apps-script/reference/spreadsheet/spreadsheet#setSpreadsheetTheme(SpreadsheetTheme)). \n\n### Methods\n\n| Method | Return type | Brief description |\n|-----------------------------------------------------------------------------------------------------------------|-------------------------------------------------------------------------|--------------------------------------------------------------------------------------------------------------------------------------------------------------------------|\n| [getConcreteColor(themeColorType)](#getConcreteColor(ThemeColorType)) | [Color](/apps-script/reference/spreadsheet/color) | Returns the concrete [Color](/apps-script/reference/spreadsheet/color) for a valid theme color type. |\n| [getFontFamily()](#getFontFamily()) | `String` | Returns the font family of the theme, or `null` if it's a `null` theme. |\n| [getThemeColors()](#getThemeColors()) | [ThemeColorType[]](/apps-script/reference/spreadsheet/theme-color-type) | Returns a list of all possible theme color types for the current theme. |\n| [setConcreteColor(themeColorType, color)](#setConcreteColor(ThemeColorType,Color)) | [SpreadsheetTheme](#) | Sets the concrete color associated with the [ThemeColorType](/apps-script/reference/spreadsheet/theme-color-type) in this color scheme to the given color. |\n| [setConcreteColor(themeColorType, red, green, blue)](#setConcreteColor(ThemeColorType,Integer,Integer,Integer)) | [SpreadsheetTheme](#) | Sets the concrete color associated with the [ThemeColorType](/apps-script/reference/spreadsheet/theme-color-type) in this color scheme to the given color in RGB format. |\n| [setFontFamily(fontFamily)](#setFontFamily(String)) | [SpreadsheetTheme](#) | Sets the font family for the theme. |\n\nDetailed documentation\n----------------------\n\n### `get``Concrete``Color(themeColorType)`\n\nReturns the concrete [Color](/apps-script/reference/spreadsheet/color) for a valid theme color type. Throws exception if the theme\ncolor type is not set in the current theme.\n\n#### Parameters\n\n| Name | Type | Description |\n|----------------------|-----------------------------------------------------------------------|-------------------|\n| `theme``Color``Type` | [ThemeColorType](/apps-script/reference/spreadsheet/theme-color-type) | Theme color type. |\n\n#### Return\n\n\n[Color](/apps-script/reference/spreadsheet/color) --- Concrete color.\n\n#### Authorization\n\nScripts that use this method require authorization with one or more of the following [scopes](/apps-script/concepts/scopes#setting_explicit_scopes):\n\n- `https://www.googleapis.com/auth/spreadsheets.currentonly`\n- `https://www.googleapis.com/auth/spreadsheets`\n\n*** ** * ** ***\n\n### `get``Font``Family()`\n\nReturns the font family of the theme, or `null` if it's a `null` theme.\n\n#### Return\n\n\n`String` --- The theme font family.\n\n#### Authorization\n\nScripts that use this method require authorization with one or more of the following [scopes](/apps-script/concepts/scopes#setting_explicit_scopes):\n\n- `https://www.googleapis.com/auth/spreadsheets.currentonly`\n- `https://www.googleapis.com/auth/spreadsheets`\n\n*** ** * ** ***\n\n### `get``Theme``Colors()`\n\nReturns a list of all possible theme color types for the current theme.\n\n#### Return\n\n\n[ThemeColorType[]](/apps-script/reference/spreadsheet/theme-color-type) --- A list of theme colors.\n\n#### Authorization\n\nScripts that use this method require authorization with one or more of the following [scopes](/apps-script/concepts/scopes#setting_explicit_scopes):\n\n- `https://www.googleapis.com/auth/spreadsheets.currentonly`\n- `https://www.googleapis.com/auth/spreadsheets`\n\n*** ** * ** ***\n\n### `set``Concrete``Color(themeColorType, color)`\n\nSets the concrete color associated with the [ThemeColorType](/apps-script/reference/spreadsheet/theme-color-type) in this color scheme to the\ngiven color.\n\n#### Parameters\n\n| Name | Type | Description |\n|----------------------|-----------------------------------------------------------------------|-----------------------|\n| `theme``Color``Type` | [ThemeColorType](/apps-script/reference/spreadsheet/theme-color-type) | The theme color type. |\n| `color` | [Color](/apps-script/reference/spreadsheet/color) | The color. |\n\n#### Return\n\n\n[SpreadsheetTheme](#) --- The theme, for chaining.\n\n#### Authorization\n\nScripts that use this method require authorization with one or more of the following [scopes](/apps-script/concepts/scopes#setting_explicit_scopes):\n\n- `https://www.googleapis.com/auth/spreadsheets.currentonly`\n- `https://www.googleapis.com/auth/spreadsheets`\n\n*** ** * ** ***\n\n### `set``Concrete``Color(themeColorType, red, green, blue)`\n\nSets the concrete color associated with the [ThemeColorType](/apps-script/reference/spreadsheet/theme-color-type) in this color scheme to the\ngiven color in RGB format.\n\n#### Parameters\n\n| Name | Type | Description |\n|----------------------|-----------------------------------------------------------------------|-----------------------------|\n| `theme``Color``Type` | [ThemeColorType](/apps-script/reference/spreadsheet/theme-color-type) | The theme color type. |\n| `red` | `Integer` | The value of red channel. |\n| `green` | `Integer` | The value of green channel. |\n| `blue` | `Integer` | The value of blue channel. |\n\n#### Return\n\n\n[SpreadsheetTheme](#) --- The theme, for chaining.\n\n#### Authorization\n\nScripts that use this method require authorization with one or more of the following [scopes](/apps-script/concepts/scopes#setting_explicit_scopes):\n\n- `https://www.googleapis.com/auth/spreadsheets.currentonly`\n- `https://www.googleapis.com/auth/spreadsheets`\n\n*** ** * ** ***\n\n### `set``Font``Family(fontFamily)`\n\nSets the font family for the theme.\n\n#### Parameters\n\n| Name | Type | Description |\n|----------------|----------|----------------------------|\n| `font``Family` | `String` | The new theme font family. |\n\n#### Return\n\n\n[SpreadsheetTheme](#) --- This theme, for chaining.\n\n#### Authorization\n\nScripts that use this method require authorization with one or more of the following [scopes](/apps-script/concepts/scopes#setting_explicit_scopes):\n\n- `https://www.googleapis.com/auth/spreadsheets.currentonly`\n- `https://www.googleapis.com/auth/spreadsheets`"]]
