Themes and colors help you enhance the overall appearance of the workbook. The appearance of the workbook contributes significantly to the ability to read, understand, and work with it. DsExcel supports both built-in and custom themes and colors, as described in the following sections:

• Themes
• Theme, Standard, and Custom Colors

Themes

DsExcel provides setTheme method of Workbook class and IWorkbook interface that allows you to set a theme for the workbook. You can change the current theme of the workbook using setTheme method and Themes class. The default theme of a workbook is the standard Office theme.

Furthermore, DsExcel also provides Theme class that enables you to create a custom theme and apply it to set up a workbook according to your preferences and requirements.

When a theme is changed, it affects all areas, including the theme font, theme color, range, chart title, etc. For instance, if you apply a built-in or a custom theme to your workbook, it is likely that the color of the range as well as the font will also be changed in accordance with the modified theme.

Set Built-in Theme

Refer to the following example code to set a built-in theme:

// Change workbook's theme to Berlin.
workbook.setTheme(Themes.GetBerlin());

Set Custom Theme

Refer to the following example code to set a custom theme:

// Add custom theme. Base theme is office theme, if parameters are not given.
Theme theme = new Theme("testTheme");

theme.getThemeColorScheme().get(ThemeColor.Light1).setRGB(Color.GetAntiqueWhite());
theme.getThemeColorScheme().get(ThemeColor.Accent1).setRGB(Color.GetAliceBlue());
theme.getThemeFontScheme().getMajor().get(FontLanguageIndex.Latin).setName("Buxton Sketch");
theme.getThemeFontScheme().getMinor().get(FontLanguageIndex.Latin).setName("Segoe UI");
        
// Apply theme.
workbook.setTheme(theme);

Theme, Standard, and Custom Colors

DsExcel allows you to set the color of a cell, cell border, tab, etc., using theme colors, standard colors, and custom colors. You can set these colors using stringToColor method of ColorUtilities class, setThemeColor method, and ThemeColor enumeration.

setThemeColor method sets the built-in theme colors using ThemeColor enumeration. Whereas stringToColor method of ColorUtilities class sets the standard and custom colors using different color string formats, such as:

• Color name: A predefined standard color name.
  Example: "red".
• RGB: rgb(r,g,b)
  Example: "rgb(255,0,0)" for red.
• RGBA: rgba(r,g,b,a)
  Example: "rgba(255,0,0,0.5)" for red with 50% opacity.
• Hexadecimal: #RGB or #RRGGBB
  Example: "#F00" or "#FF0000" for red.
• Hexadecimal with alpha: #RGBA or #RRGGBBAA
  Example: "#F00C" or "#FF0000CC" for red with 90% opacity.

Set Theme Color

Refer to the following example code to set the interior and border color of a cell to theme color:

// Set interior and border color to theme color.
worksheet.getRange("D2").getInterior().setThemeColor(ThemeColor.Accent1);
worksheet.getRange("D2").getBorders().setThemeColor(ThemeColor.Accent2);

Set Standard Color

Refer to the following example code to set the interior and border color of a range to standard color:

// Set interior and border color to standard color.
worksheet.getRange("B4:D6").getInterior().setColor(ColorUtilities.stringToColor("yellow"));
worksheet.getRange("C4:D6").getBorders().setColor(ColorUtilities.stringToColor("black"));

Set Custom Color

Refer to the following example code to set the interior and border colors of a range to a custom color using RGB and hexadecimal color strings:

// Set interior and border color to custom color.
worksheet.getRange("B7:B18").getInterior().setColor(ColorUtilities.stringToColor("rgb(211,211,211)"));
worksheet.getRange("B7:D18").getBorders().setColor(ColorUtilities.stringToColor("#000000"));