Styling¶

Cells are styled through the Style property of a range, which gives access to number formats, fonts, fills, borders and alignment. EPPlus also supports named styles, conditional formatting, themes and custom named styles for tables, pivot tables and slicers.

• Formatting and styling - Set number formats, fonts, fills and borders on a range, and create your own named styles.
• The ExcelRange.Text property - How EPPlus formats a cell value as text, and how to handle culture-specific number formats.
• Conditional formatting - Style cells based on their values. EPPlus supports 45 types of conditional formatting, including color scales, icon sets and data bars.
• Using Themes - Load a theme exported from Excel (thmx) and change it through the ThemeManager.
• Working with custom named table- or slicer- styles - Create your own styles for tables, pivot tables and slicers, from scratch or based on an existing style.

See also¶

• Built in Table styles
• Styling Charts