Adding Custom style for Pivot table epplus

Question

Hi i have successfully created a pivot table using EPPlus and i have requirement to change the default color style in pivot table ,how can i achieve this in epplus

Answer 1

You can set the TableStyle of the pivot table like this. Here Dark2 is chosen, but there's plenty to choose from.

pivotTable.TableStyle = OfficeOpenXml.Table.TableStyles.Dark2;