From EPPlus version 5.6 you can create your own custom pivot table styles. Custom named styles are created via the `ExcelPackage.Workbook.Styles` property. Custom styles can either be created from scratch or use a build-in or another custom style as a template. The samples below are from our sample project -Sample 7.4 - [C\#]() or [Visual Basic]() ## Samples ### Custom pivot table styles A custom pivot table style is created via the `CreatePivotTableStyle` or the `CreateTableAndPivotTableStyle` method. ```csharp //Create a named style that applies only to pivot tables. var customPivotTableStyle = p.Workbook.Styles.CreatePivotTableStyle(styleName); customPivotTableStyle.WholeTable.Style.Font.Color.SetColor(ExcelIndexedColor.Indexed22); customPivotTableStyle.PageFieldLabels.Style.Font.Color.SetColor(Color.Red); customPivotTableStyle.PageFieldValues.Style.Font.Color.SetColor(eThemeSchemeColor.Accent4); customPivotTableStyle.HeaderRow.Style.Font.Color.SetColor(Color.DarkGray); customPivotTableStyle.HeaderRow.Style.Fill.Style = eDxfFillStyle.GradientFill; customPivotTableStyle.HeaderRow.Style.Fill.Gradient.Degree = 180; var c1 = customPivotTableStyle.HeaderRow.Style.Fill.Gradient.Colors.Add(0); c1.Color.SetColor(Color.LightBlue); var c3 = customPivotTableStyle.HeaderRow.Style.Fill.Gradient.Colors.Add(100); c3.Color.SetColor(Color.DarkCyan); ``` ```vbnet 'Create a named style that applies only to pivot tables. Dim customPivotTableStyle = p.Workbook.Styles.CreatePivotTableStyle(styleName) customPivotTableStyle.WholeTable.Style.Font.Color.SetColor(ExcelIndexedColor.Indexed22) customPivotTableStyle.PageFieldLabels.Style.Font.Color.SetColor(Color.Red) customPivotTableStyle.PageFieldValues.Style.Font.Color.SetColor(eThemeSchemeColor.Accent4) customPivotTableStyle.HeaderRow.Style.Font.Color.SetColor(Color.DarkGray) customPivotTableStyle.HeaderRow.Style.Fill.Style = eDxfFillStyle.GradientFill customPivotTableStyle.HeaderRow.Style.Fill.Gradient.Degree = 180 Dim c1 = customPivotTableStyle.HeaderRow.Style.Fill.Gradient.Colors.Add(0) c1.Color.SetColor(Color.LightBlue) Dim c3 = customPivotTableStyle.HeaderRow.Style.Fill.Gradient.Colors.Add(100) c3.Color.SetColor(Color.DarkCyan) ``` You can also create a named table style that can be applied to both tables and pivot tables. This style will have all elements for both tables and pivot tables. ```csharp //Create a named style that can be used both for tables and pivot tables. //We create this style from one of the build in pivot table styles - Medium13, but table styles can also be used as a parameter for this method var customTableStyle = p.Workbook.Styles.CreateTableAndPivotTableStyle(customTableStyle3, PivotTableStyles.Medium13); ``` ```vbnet 'Create a named style that can be used both for tables and pivot tables. 'We create this style from one of the build in pivot table styles - Medium13, but table styles can also be used as a parameter for this method Dim customTableStyle = p.Workbook.Styles.CreateTableAndPivotTableStyle(customTableStyle3, PivotTableStyles.Medium13) ``` To apply a custom table style to a table or pivot table you only need to set the `StyleName` property to the name you choose for you style. ```csharp table1.StyleName = "Custom Table Style 1"; ``` ```vbnet table1.StyleName = "Custom Table Style 1" ``` ### Custom Slicer Styles In the same way as you create custom table style you can create named styles from slicers. A named slicer style is created with the `CreateSlicerStyle` method... ```csharp //Slicers can also be styled by creating a named style. Here we use the build in Light 5 as a template and changes the font of the slicer. //See Sample 27 for more detailed samples. var slicer = pivotTable4.Fields["CompanyName"].Slicer; var styleName = "CustomSlicerStyle1"; var style = pck.Workbook.Styles.CreateSlicerStyle(styleName, eSlicerStyle.Light5); style.WholeTable.Style.Font.Name = "Stencil"; slicer.StyleName = styleName; ``` ```vbnet 'Slicers can also be styled by creating a named style. Here we use the build in Light 5 as a template and changes the font of the slicer. 'See Sample 27 for more detailed samples. Dim slicer = pivotTable4.Fields("CompanyName").Slicer Dim styleName = "CustomSlicerStyle1" Dim style = pck.Workbook.Styles.CreateSlicerStyle(styleName, eSlicerStyle.Light5) style.WholeTable.Style.Font.Name = "Stencil" slicer.StyleName = styleName ``` \[\[Images/CustomSlicerStyle1.PNG\]\] The slicer styles contains slicer unique elements, like `SelectedItemWithData` in the code below, that can have different styles. ```csharp //Create a named style that applies to slicers with a console feel to the style. var customSlicerStyle = p.Workbook.Styles.CreateSlicerStyle(styleName); customSlicerStyle.WholeTable.Style.Font.Name = "Consolas"; customSlicerStyle.WholeTable.Style.Font.Size = 12; customSlicerStyle.WholeTable.Style.Font.Color.SetColor(Color.WhiteSmoke); customSlicerStyle.WholeTable.Style.Fill.BackgroundColor.SetColor(Color.Black); customSlicerStyle.SelectedItemWithData.Style.Fill.BackgroundColor.SetColor(Color.Gray); customSlicerStyle.SelectedItemWithData.Style.Border.BorderAround(ExcelBorderStyle.Thin, Color.DarkGray); ``` ```vbnet 'Create a named style that applies to slicers with a console feel to the style. Dim customSlicerStyle = p.Workbook.Styles.CreateSlicerStyle(styleName) customSlicerStyle.WholeTable.Style.Font.Name = "Consolas" customSlicerStyle.WholeTable.Style.Font.Size = 12 customSlicerStyle.WholeTable.Style.Font.Color.SetColor(Color.WhiteSmoke) customSlicerStyle.WholeTable.Style.Fill.BackgroundColor.SetColor(Color.Black) customSlicerStyle.SelectedItemWithData.Style.Fill.BackgroundColor.SetColor(Color.Gray) customSlicerStyle.SelectedItemWithData.Style.Border.BorderAround(ExcelBorderStyle.Thin, Color.DarkGray) ``` ### See also - [Sample 7.4-C\#]() or [Sample 7.4-VB]() - [Pivot tables]()