Enum PivotStyleType

Represents the built-in pivot table styles available in the Excel "PivotTable Design > PivotTable Styles" gallery.

Namespace: DRIT.Spreadsheet.Pivot

Assembly: DRIT.Spreadsheet.dll

Syntax

public enum PivotStyleType

Remarks

The enum member names match the built-in style names used in the OOXML pivotTableStyleInfo name attribute (e.g. PivotStyleLight16).

Excel UI: "PivotTable Design > PivotTable Styles" gallery, organized into Light, Medium, and Dark groups.

Fields

Name	Description
None	No built-in pivot table style.
PivotStyleDark1	Selects built-in dark pivot-table style 1.
PivotStyleDark10	Selects built-in dark pivot-table style 10.
PivotStyleDark11	Selects built-in dark pivot-table style 11.
PivotStyleDark2	Selects built-in dark pivot-table style 2.
PivotStyleDark3	Selects built-in dark pivot-table style 3.
PivotStyleDark4	Selects built-in dark pivot-table style 4.
PivotStyleDark5	Selects built-in dark pivot-table style 5.
PivotStyleDark6	Selects built-in dark pivot-table style 6.
PivotStyleDark7	Selects built-in dark pivot-table style 7.
PivotStyleDark8	Selects built-in dark pivot-table style 8.
PivotStyleDark9	Selects built-in dark pivot-table style 9.
PivotStyleLight1	Selects built-in light pivot-table style 1.
PivotStyleLight10	Selects built-in light pivot-table style 10.
PivotStyleLight11	Selects built-in light pivot-table style 11.
PivotStyleLight12	Selects built-in light pivot-table style 12.
PivotStyleLight13	Selects built-in light pivot-table style 13.
PivotStyleLight14	Selects built-in light pivot-table style 14.
PivotStyleLight15	Selects built-in light pivot-table style 15.
PivotStyleLight16	Selects built-in light pivot-table style 16.
PivotStyleLight17	Selects built-in light pivot-table style 17.
PivotStyleLight18	Selects built-in light pivot-table style 18.
PivotStyleLight19	Selects built-in light pivot-table style 19.
PivotStyleLight2	Selects built-in light pivot-table style 2.
PivotStyleLight20	Selects built-in light pivot-table style 20.
PivotStyleLight21	Selects built-in light pivot-table style 21.
PivotStyleLight22	Selects built-in light pivot-table style 22.
PivotStyleLight23	Selects built-in light pivot-table style 23.
PivotStyleLight24	Selects built-in light pivot-table style 24.
PivotStyleLight25	Selects built-in light pivot-table style 25.
PivotStyleLight26	Selects built-in light pivot-table style 26.
PivotStyleLight27	Selects built-in light pivot-table style 27.
PivotStyleLight28	Selects built-in light pivot-table style 28.
PivotStyleLight3	Selects built-in light pivot-table style 3.
PivotStyleLight4	Selects built-in light pivot-table style 4.
PivotStyleLight5	Selects built-in light pivot-table style 5.
PivotStyleLight6	Selects built-in light pivot-table style 6.
PivotStyleLight7	Selects built-in light pivot-table style 7.
PivotStyleLight8	Selects built-in light pivot-table style 8.
PivotStyleLight9	Selects built-in light pivot-table style 9.
PivotStyleMedium1	Selects built-in medium pivot-table style 1.
PivotStyleMedium10	Selects built-in medium pivot-table style 10.
PivotStyleMedium11	Selects built-in medium pivot-table style 11.
PivotStyleMedium12	Selects built-in medium pivot-table style 12.
PivotStyleMedium13	Selects built-in medium pivot-table style 13.
PivotStyleMedium14	Selects built-in medium pivot-table style 14.
PivotStyleMedium15	Selects built-in medium pivot-table style 15.
PivotStyleMedium16	Selects built-in medium pivot-table style 16.
PivotStyleMedium17	Selects built-in medium pivot-table style 17.
PivotStyleMedium18	Selects built-in medium pivot-table style 18.
PivotStyleMedium19	Selects built-in medium pivot-table style 19.
PivotStyleMedium2	Selects built-in medium pivot-table style 2.
PivotStyleMedium20	Selects built-in medium pivot-table style 20.
PivotStyleMedium21	Selects built-in medium pivot-table style 21.
PivotStyleMedium22	Selects built-in medium pivot-table style 22.
PivotStyleMedium23	Selects built-in medium pivot-table style 23.
PivotStyleMedium24	Selects built-in medium pivot-table style 24.
PivotStyleMedium25	Selects built-in medium pivot-table style 25.
PivotStyleMedium26	Selects built-in medium pivot-table style 26.
PivotStyleMedium27	Selects built-in medium pivot-table style 27.
PivotStyleMedium28	Selects built-in medium pivot-table style 28.
PivotStyleMedium3	Selects built-in medium pivot-table style 3.
PivotStyleMedium4	Selects built-in medium pivot-table style 4.
PivotStyleMedium5	Selects built-in medium pivot-table style 5.
PivotStyleMedium6	Selects built-in medium pivot-table style 6.
PivotStyleMedium7	Selects built-in medium pivot-table style 7.
PivotStyleMedium8	Selects built-in medium pivot-table style 8.
PivotStyleMedium9	Selects built-in medium pivot-table style 9.