wb.pivotTableStyles

WorkbookPivotTableStyles

5 methods

→ Promise<string>

getDefault(): Promise<string>;

Get the workbook's default pivot table style preset. Returns 'PivotStyleLight16' if not explicitly set.

→ Promise<void>

setDefault(style: string | null): Promise<void>;

Parameter	Type	Required
style	string \| null	required

Set the workbook's default pivot table style preset. Pass null to reset to 'PivotStyleLight16'.

→ Promise<number>

getCount(): Promise<number>;

Get the count of built-in pivot table styles.

→ Promise<PivotTableStyleInfo | null>

getItem(name: string): Promise<PivotTableStyleInfo | null>;

Parameter	Type	Required
name	string	required

Get a pivot table style by name, or null if not found.

→ Promise<PivotTableStyleInfo[]>

list(): Promise<PivotTableStyleInfo[]>;

List all built-in pivot table styles.