Applying Theme to Customize the Appearance

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.

C#	Copy Code
// 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);

Copy Code

// 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);

VB	Copy Code
' 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)

Copy Code

' 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.

C#	Copy Code
// 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);

Copy Code

// 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);

VB	Copy Code
' 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)

Copy Code

' 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.

C#	Copy Code
// 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);

Copy Code

// 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);

VB	Copy Code
' 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)

Copy Code

' 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.

C#	Copy Code
//To remove a theme fpSpread1.AsWorkbook().ApplyTheme(""); fpSpread2.AsWorkbook().ApplyTheme("");

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