FUniverPivotTableEventMixin
| packages | @univerjs-pro/sheets-pivot |
|---|
APIs
_initialize
Signature
_initialize(injector: Injector): voidgeneratePivotTable
Create a pivot table instance that does not depend on a workbook
Signature
generatePivotTable<T extends DataFieldManager>(data: IDataFieldDataArray, CustomDataFieldManager?: new (...args: unknown[]) => T): FGenericPivotTableParameters
data(IDataFieldDataArray) — - The data used to create the pivot tableCustomDataFieldManager(new (...args: unknown[]) => T) — - The custom data field manager class. If not passed, the default DataFieldManager will be used
Returns
- (
FGenericPivotTable) — The generated pivot table instance.
Examples
const sourceData = [
['区域', '省份', '城市', '类别', '商品', '数量', '销售日期'],
['西部', '河南', '洛阳', 'fruit', '葡萄', 38, '2021-06-30'],
['北部', '辽宁', '沈阳', 'fruit', '葡萄', 45, '2023-08-31'],
]
const pivot = univerAPI.generatePivotTable(sourceData)
pivot.addFieldWithName('数量', 3)
const res = pivot.getResultByCalculate()
console.log('debugger', pivot, res)