Format Pivot Table

Jan 31 at 5:01 PM
I am using the pivot table functionality, which is working out great except I'm having issues with formatting.
  • Is it possible to apply specific formatting on a pivot table outside of using the built in TableStyles? For example, I have requirements to make the font in the pivot table Arial Narrow with a size of 10 font and text centered. I can easily do this on the worksheet itself, but I have yet to find a way to do this on the pivot table. I see the OfficeOpenXml.Table.TableStyles.Custom, but I don't quite understand what that does, same with ExcelPivotTable.StyleName.
  • Is there any way to set the Banded Rows and Banded Columns to true/on in the pivot table? Is there another way to basically show the gridlines on the pivot table?
Any help would be much appreciated. If the above is not possible in EPPlus, can someone please let me know?