Excel.BuiltInPivotTableStyle enum
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 |