EPPlus 5/6/7

EPPlus

EPPlus supports themes from version 5 and up. Themes can be handled and loaded via the ThemeManager class exposed by the ExcelPackage.Workbook Property. The ThemeManager can load .thmx files(exported from Excel) and apply them to a workbook. The ThemeManager also supports creating themes with code.

        
using(var package = new ExcelPackage()
{
    package.Workbook.ThemeManager.Load(new FileInfo("integral.thmx"));

    //Themes can also be altered, for use this code to set the Accent1 color. 
    package.Workbook.ThemeManager.CurrentTheme.ColorScheme.Accent1.SetRgbColor(Color.FromArgb(32, 78, 224));    //Blue color
}
            
        

Adding a theme to your workbook will change the appearance of your workbook. For example the fonts and the styles of drawing objects.

Here are some screenshorts from sample 15 in our sample project.

        
            //The theme is applied when setting the chart style of the bubble chart.
            chart.StyleManager.SetChartStyle(ePresetChartStyleMultiSeries.BubbleChartStyle10);
        
        

!

See also

• More chart samples
• Sample 5.3 C#
• Sample 5.3 VB.NET