HI, is possible background color for subtotals pivot ??
thanks
Workbook wb = new Workbook();
wb.LoadFromFile(@"sample.xlsx");
XlsPivotTable pivotTable = wb.Worksheets["Pivot Table"].PivotTables[0] as XlsPivotTable;
//custom the style
string styleName = "newone";
pivotTable.CustomTableStyleName = styleName;
PivotTableStyle pivotTableStyle = new PivotTableStyle(styleName);
PivotStyle pivotStyle = wb.CreatePivotStyle();
pivotStyle.Fill.PatternColorObject.SetKnownColor(ExcelColors.Blue);
//apply the style where you need to add
pivotTableStyle.Styles.Add(PivotTableElement.thirdSubtotalRow, pivotStyle);
wb.AddPivotTableStyle(pivotTableStyle);
wb.SaveToFile("result.xlsx", ExcelVersion.Version2007);