Skip to content

Using Themes

Jan Källman edited this page Jan 27, 2020 · 10 revisions

EPPlus 5 support creating and loading themes. Themes can be created or loaded via the Workbook.ThemeManager. A theme can be exported from Excel using the thmx format an then loaded via EPPLus:

   package.Workbook.ThemeManager.Load(FileInputUtil.GetFileInfo("15-ChartsAndThemes", "integral.thmx"));

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

EPPlus wiki

Versions

Worksheet & Ranges

Styling

Import/Export data

Formulas and filters

Charts & Drawing objects

Tables & Pivot Tables

VBA & Protection

Clone this wiki locally