API Reference

@univerjs-pro/sheets-pivot

Pivot table integration for Univer Sheets.

TypeScript
import { UniverSheetsPivotTablePlugin } from '@univerjs-pro/sheets-pivot'univer.registerPlugin(UniverSheetsPivotTablePlugin, IUniverSheetsPivotConfig)

Entry Points

  • Facade: @univerjs-pro/sheets-pivot/facade
  • Locale: @univerjs-pro/sheets-pivot/locale/*

IUniverSheetsPivotConfig

TypeScript
export interface IUniverSheetsPivotConfig {  notExecuteFormula?: boolean  // When the user configures this property,  // if there are cells containing data in the pivot table next view range,  // they will be directly overwritten without popping up a dialog box for the user to select.  defaultOverride?: boolean  /**   * Define the maximum number of items that can be displayed in a single pivot table field. The default value is 1000.   */  maxLimitItemCount?: number}

How is this guide?

© 2026 DreamNum Co., Ltd.