-
Notifications
You must be signed in to change notification settings - Fork 295
Using Themes
JanKallman edited this page Oct 19, 2023
·
10 revisions
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.
EPPlus Software AB - https://epplussoftware.com
- What is new in EPPlus 5+
- Breaking Changes in EPPlus 5
- Breaking Changes in EPPlus 6
- Breaking Changes in EPPlus 7
- Breaking Changes in EPPlus 8
- Addressing a worksheet
- Dimension/Used range
- Copying ranges/sheets
- Insert/Delete
- Filling ranges
- Sorting ranges
- Taking and skipping columns/rows
- Data validation
- Comments
- Freeze and Split Panes
- Header and Footer
- Hyperlinks
- Autofit columns
- Grouping and Ungrouping Rows and Columns
- Formatting and styling
- The ExcelRange.Text property
- Conditional formatting
- Using Themes
- Working with custom named table- or slicer- styles