This project has moved and is read-only. For the latest updates, please go here.

Colring Pivot Table

Feb 12, 2013 at 5:34 AM
How to give color to Pivot Table in excel Sheet ,which is generated through epplus.

Thanks in advance
Feb 12, 2013 at 5:40 PM
Edited Feb 12, 2013 at 6:30 PM
You can assign one of the sixty TableStyles to set a color scheme to the pivot table.

For example: pivotTable.TableStyle = TableStyles.Medium2;
Feb 18, 2013 at 3:44 PM
Thank you for ur reply..

but i need to conditional format pivot table... i.e, giving certain colors based on values in the pivot sheet.

Thanks in advance
Feb 25, 2013 at 12:41 PM
I can conditional format excel data, but i cannot apply conditional format pivot table. I think this feature is not provided in EPPLus