Edit

Share via

Excel.BuiltInPivotTableStyle enum

  • Reference
Package:
excel

Note

This API is provided as a preview for developers and may change based on feedback that we receive. Do not use this API in a production environment.

Represents a built-in PivotTable style

Remarks

[ API set: ExcelApi BETA (PREVIEW ONLY) ]

Fields

dark1 = "Dark1"

"Dark 1" (black in the default "Office" theme) with filled header, striped rows, and shaded body.
dark10 = "Dark10"

"Accent 2" (orange in the default "Office" theme) with filled header, striped rows, and outside border.
dark11 = "Dark11"

"Accent 3" (gray in the default "Office" theme) with filled header, striped rows, and outside border.
dark12 = "Dark12"

"Accent 4" (yellow in the default "Office" theme) with filled header, striped rows, and outside border.
dark13 = "Dark13"

"Accent 5" (light blue in the default "Office" theme) with filled header, striped rows, and outside border.
dark14 = "Dark14"

"Accent 6" (green in the default "Office" theme) with filled header, striped rows, and outside border.
dark15 = "Dark15"

"Dark 1" (black in the default "Office" theme) with filled header, filled footer, and striped rows.
dark16 = "Dark16"

"Accent 1" (blue in the default "Office" theme) with filled header, filled footer, and striped rows.
dark17 = "Dark17"

"Accent 2" (orange in the default "Office" theme) with filled header, filled footer, and striped rows.
dark18 = "Dark18"

"Accent 3" (gray in the default "Office" theme) with filled header, filled footer, and striped rows.
dark19 = "Dark19"

"Accent 4" (yellow in the default "Office" theme) with filled header, filled footer, and striped rows.
dark2 = "Dark2"

"Accent 1" (blue in the default "Office" theme) with filled header, striped rows, and shaded body.
dark20 = "Dark20"

"Accent 5" (light blue in the default "Office" theme) with filled header, filled footer, and striped rows.
dark21 = "Dark21"

"Accent 6" (green in the default "Office" theme) with filled header, filled footer, and striped rows.
dark22 = "Dark22"

"Dark 1" (black in the default "Office" theme) with shaded body, and white borders.
dark23 = "Dark23"

"Accent 1" (blue in the default "Office" theme) with shaded body, and white borders.
dark24 = "Dark24"

"Accent 2" (orange in the default "Office" theme) with shaded body, and white borders.
dark25 = "Dark25"

"Accent 3" (gray in the default "Office" theme) with shaded body, and white borders.
dark26 = "Dark26"

"Accent 4" (yellow in the default "Office" theme) with shaded body, and white borders.
dark27 = "Dark27"

"Accent 5" (light blue in the default "Office" theme) with shaded body, and white borders.
dark28 = "Dark28"

"Accent 6" (green in the default "Office" theme) with shaded body, and white borders.
dark3 = "Dark3"

"Accent 2" (orange in the default "Office" theme) with filled header, striped rows, and shaded body.
dark4 = "Dark4"

"Accent 3" (gray in the default "Office" theme) with filled header, striped rows, and shaded body.
dark5 = "Dark5"

"Accent 4" (yellow in the default "Office" theme) with filled header, striped rows, and shaded body.
dark6 = "Dark6"

"Accent 5" (light blue in the default "Office" theme) with filled header, striped rows, and shaded body.
dark7 = "Dark7"

"Accent 6" (green in the default "Office" theme) with filled header, striped rows, and shaded body.
dark8 = "Dark8"

"Dark 1" (black in the default "Office" theme) with filled header, striped rows, and outside border.
dark9 = "Dark9"

"Accent 1" (blue in the default "Office" theme) with filled header, striped rows, and outside border.
light1 = "Light1"

"Dark 1" (black in the default "Office" theme) with header borders and footer borders.
light10 = "Light10"

"Accent 2" (orange in the default "Office" theme) with header borders, footer borders, first column border, and striped rows.
light11 = "Light11"

"Accent 3" (gray in the default "Office" theme) with header borders, footer borders, first column border, and striped rows.
light12 = "Light12"

"Accent 4" (yellow in the default "Office" theme) with header borders, footer borders, first column border, and striped rows.
light13 = "Light13"

"Accent 5" (light blue in the default "Office" theme) with header borders, footer borders, first column border, and striped rows.
light14 = "Light14"

"Accent 6" (green in the default "Office" theme) with header borders, footer borders, first column border, and striped rows.
light15 = "Light15"

"Dark 1" (black in the default "Office" theme) with filled header and striped bordered rows.
light16 = "Light16"

"Accent 1" (blue in the default "Office" theme) with filled header and striped bordered rows.
light17 = "Light17"

"Accent 2" (orange in the default "Office" theme) with filled header and striped bordered rows.
light18 = "Light18"

"Accent 3" (gray in the default "Office" theme) with filled header and striped bordered rows.
light19 = "Light19"

"Accent 4" (yellow in the default "Office" theme) with filled header and striped bordered rows.
light2 = "Light2"

"Accent 1" (blue in the default "Office" theme) with header borders and footer borders.
light20 = "Light20"

"Accent 5" (light blue in the default "Office" theme) with filled header and striped bordered rows.
light21 = "Light21"

"Accent 6" (green in the default "Office" theme) with filled header and striped bordered rows.
light22 = "Light22"

"Dark 1" (black in the default "Office" theme) with header borders, footer borders, and bordered columns.
light23 = "Light23"

"Accent 1" (blue in the default "Office" theme) with header borders, footer borders, and bordered columns.
light24 = "Light24"

"Accent 2" (orange in the default "Office" theme) with header borders, footer borders, and bordered columns.
light25 = "Light25"

"Accent 3" (gray in the default "Office" theme) with header borders, footer borders, and bordered columns.
light26 = "Light26"

"Accent 4" (yellow in the default "Office" theme) with header borders, footer borders, and bordered columns.
light27 = "Light27"

"Accent 5" (light blue in the default "Office" theme) with header borders, footer borders, and bordered columns.
light28 = "Light28"

"Accent 6" (green in the default "Office" theme) with header borders, footer borders, and bordered columns.
light3 = "Light3"

"Accent 2" (orange in the default "Office" theme) with header borders and footer borders.
light4 = "Light4"

"Accent 3" (gray in the default "Office" theme) with header borders and footer borders.
light5 = "Light5"

"Accent 4" (yellow in the default "Office" theme) with header borders and footer borders.
light6 = "Light6"

"Accent 5" (light blue in the default "Office" theme) with header borders and footer borders.
light7 = "Light7"

"Accent 6" (green in the default "Office" theme) with header borders and footer borders.
light8 = "Light8"

"Dark 1" (black in the default "Office" theme) with header borders, footer borders, first column border, and striped rows.
light9 = "Light9"

"Accent 1" (blue in the default "Office" theme) with header borders, footer borders, first column border, and striped rows.
medium1 = "Medium1"

"Dark 1" (black in the default "Office" theme) with filled header, striped rows, and footer border.
medium10 = "Medium10"

"Accent 2" (orange in the default "Office" theme) with filled header, striped rows, and total row border.
medium11 = "Medium11"

"Accent 3" (gray in the default "Office" theme) with filled header, striped rows, and total row border.
medium12 = "Medium12"

"Accent 4" (yellow in the default "Office" theme) with filled header, striped rows, and total row border.
medium13 = "Medium13"

"Accent 5" (light blue in the default "Office" theme) with filled header, striped rows, and total row border.
medium14 = "Medium14"

"Accent 6" (green in the default "Office" theme) with filled header, striped rows, and total row border.
medium15 = "Medium15"

"Dark 1" (black in the default "Office" theme) with filled header, filled footer, and shaded body.
medium16 = "Medium16"

"Accent 1" (blue in the default "Office" theme) with filled header, filled footer, and shaded body.
medium17 = "Medium17"

"Accent 2" (orange in the default "Office" theme) with filled header, filled footer, and shaded body.
medium18 = "Medium18"

"Accent 3" (gray in the default "Office" theme) with filled header, filled footer, and shaded body.
medium19 = "Medium19"

"Accent 4" (yellow in the default "Office" theme) with filled header, filled footer, and shaded body.
medium2 = "Medium2"

"Accent 1" (blue in the default "Office" theme) with filled header, striped rows, and footer border.
medium20 = "Medium20"

"Accent 5" (light blue in the default "Office" theme) with filled header, filled footer, and shaded body.
medium21 = "Medium21"

"Accent 6" (green in the default "Office" theme) with filled header, filled footer, and shaded body.
medium22 = "Medium22"

"Dark 1" (black in the default "Office" theme) with filled first column, and shaded body.
medium23 = "Medium23"

"Accent 1" (blue in the default "Office" theme) with filled first column, and shaded body.
medium24 = "Medium24"

"Accent 2" (orange in the default "Office" theme) with filled first column, and shaded body.
medium25 = "Medium25"

"Accent 3" (gray in the default "Office" theme) with filled first column, and shaded body.
medium26 = "Medium26"

"Accent 4" (yellow in the default "Office" theme) with filled first column, and shaded body.
medium27 = "Medium27"

"Accent 5" (light blue in the default "Office" theme) with filled first column, and shaded body.
medium28 = "Medium28"

"Accent 6" (green in the default "Office" theme) with filled first column, and shaded body.
medium3 = "Medium3"

"Accent 2" (orange in the default "Office" theme) with filled header, striped rows, and footer border.
medium4 = "Medium4"

"Accent 3" (gray in the default "Office" theme) with filled header, striped rows, and footer border.
medium5 = "Medium5"

"Accent 4" (yellow in the default "Office" theme) with filled header, striped rows, and footer border.
medium6 = "Medium6"

"Accent 5" (light blue in the default "Office" theme) with filled header, striped rows, and footer border.
medium7 = "Medium7"

"Accent 6" (green in the default "Office" theme) with filled header, striped rows, and footer border.
medium8 = "Medium8"

"Dark 1" (black in the default "Office" theme) with filled header, striped rows, and total row border.
medium9 = "Medium9"

"Accent 1" (blue in the default "Office" theme) with filled header, striped rows, and total row border.
none = "None"

None