Using Themes

This page has moved. The current version of this page is at https://epplussoftware.com/docs/styling/using-themes/. The EPPlus documentation is no longer updated in this wiki; please use the EPPlus guides and update your bookmarks.

EPPlus 5/6 support creating and loading themes - this is done via the Workbook.ThemeManager. A theme can be exported from Excel using the .thmx format and then loaded via EPPlus:

var thmxFile = new FileInfo("c:\\temp\\integral.thmx");
package.Workbook.ThemeManager.Load(thmxFile);

The theme can then be altered via the ThemeManager.CurrentTheme property:

// Change the color of the Accent1 theme color.
package.Workbook.ThemeManager.CurrentTheme.ColorScheme.Accent1.SetRgbColor(Color.FromArgb(32, 78, 224));

• See Sample 5.3-C# or Sample 5.3-VB
• Our web sample 1 also shows how to change themes on a workbook using exported .thmx files.