Interface: IFWorkbookSheetsPivotMixin

addPivotTable(
   sourceInfo, 
   positionType, 
anchorCellInfo): Promise<undefined | FPivotTable>

// should ensure the sheet range {0,0,8,6} is not empty
const fWorkbook = univerAPI.getActiveWorkbook()
const unitId = fWorkbook.getId()
const fSheet = fWorkbook.getActiveSheet();
const subUnitId = fSheet.getSheetId()
const sheetName = fSheet.getSheetName();
const sourceInfo = {
    unitId,
    subUnitId,
    sheetName,
    range: {
        startRow: 0,
        endRow: 8,
        startColumn: 0,
        endColumn: 6
    }
}
const anchorCellInfo = {
    unitId,
    subUnitId,
    row: 0,
    col: 8
}
const fp = await fWorkbook.addPivotTable(sourceInfo, 'exiting', anchorCellInfo)
// the addPivotTable is async, you can add pivot fields after the pivot table is added
// in the future, we will support pivot table added event, you can add pivot fields in the event handler
setTimeout(function() {
    fp.addField(1, 2)
    fp.addField(1, 3)
}, 1000)

getPivotTableByCell(
   unitId, 
   subUnitId, 
   row, 
   col): undefined | FPivotTable