You can now easily modify the look & feel of your workbook using the provided themes. Spread themes include options to set the theme color, theme fonts, and theme effects. You can also customize these individual elements and manage overall appearance of the workbook. The tasks that relate to setting the appearance of the workbook include:

• Applying a New Theme
• Customizing the Theme Fonts
• Customizing the Theme Colors
• Removing a Theme

Spread themes are shared across all Spread components to provide a uniform look.  In case a theme is not specified, default theme settings of are applied to the workbook. 

Applying a New Theme

Use the following code to apply any theme to the workbook to modify the apperance.

// To apply a new theme.
var fileName = @"C:\Program Files\Microsoft Office\root\Document Themes 16\Gallery.thmx";
fpSpread1.AsWorkbook().ApplyTheme(fileName);
fpSpread2.AsWorkbook().ApplyTheme(fpSpread1.AsWorkbook().Theme);

' To apply a new theme.
Dim fileName As var =  "C:\Program Files\Microsoft Office\root\Document Themes 16\Gallery.thmx"
fpSpread1.AsWorkbook().ApplyTheme(fileName)
fpSpread2.AsWorkbook().ApplyTheme(fpSpread1.AsWorkbook().Theme)

Customizing the Theme Fonts

Theme fonts contain a heading font and a body text font. You can change both of these fonts to create your own set of theme fonts. Refer to the following code snippet to customize the font scheme of your workbook.

// To customize theme fonts.
string fileName = @"C:\Program Files\Microsoft Office\root\Document Themes 16\Theme Fonts\Century Gothic.xml";
fpSpread1.AsWorkbook().Theme.FontScheme.Load(fileName);
fpSpread2.AsWorkbook().Theme.FontScheme.Load(fileName);

' To customize theme fonts.
Dim fileName As String =  "C:\Program Files\Microsoft Office\root\Document Themes 16\Theme Fonts\Century Gothic.xml"
fpSpread1.AsWorkbook().Theme.FontScheme.Load(fileName)
fpSpread2.AsWorkbook().Theme.FontScheme.Load(fileName)

Customizing the Theme Colors

Refer to the following code snippet to customize the theme colors of your workbook.

// To customize theme colors.
string fileName = @"C:\Program Files\Microsoft Office\root\Document Themes 16\Theme Colors\Yellow Orange.xml";
fpSpread1.AsWorkbook().Theme.ColorScheme.Load(fileName);
fpSpread2.AsWorkbook().Theme.ColorScheme.Load(fileName);

' To customize theme colors.
Dim fileName As String =  "C:\Program Files\Microsoft Office\root\Document Themes 16\Theme Colors\Yellow Orange.xml"
fpSpread1.AsWorkbook().Theme.ColorScheme.Load(fileName)
fpSpread2.AsWorkbook().Theme.ColorScheme.Load(fileName)

Removing a Theme

Refer to the following code snippet to remove the currently applied theme from your workbook and change it back to the default theme.

//To remove a theme
fpSpread1.AsWorkbook().ApplyTheme("");
fpSpread2.AsWorkbook().ApplyTheme("");

' To remove a theme
fpSpread1.AsWorkbook().ApplyTheme("")
fpSpread2.AsWorkbook().ApplyTheme("")