Error while clearing pivot data

Aspose.Cells Product Family
1

I am trying to clear workjbook in the event of errors below is my code

async function addPivotSheetToWorkbook(workBook, reportsData, runInfoData) {
    try {
        const worksheet = workBook.getWorksheets().get(0);
        const range = worksheet.getCells().getMaxDisplayRange();
        const rangeOfExcel = range.getRefersTo();
        workBook = await createPivotBasedOnRange(
            workBook,
            rangeOfExcel,
            reportsData
        );
        return workBook;
    } catch (err) {
        const outOfMemoryError = err?.message.includes('OutOfMemoryError');
        const uniqueItemsError = err?.message.includes(
            'This pivot field has more unique items than can be used in a pivot table'
        );
        if (workBook.getWorksheets().getCount() > 2) {
            const pivotSheet = workBook.getWorksheets().get(2);
            const pivotTables = pivotSheet.getPivotTables();
            pivotTables.get(0).clearData();
            workBook.getWorksheets().removeAt(2);
        }
}
}

I am getting this error

Error running instance method\njava.lang.IllegalArgumentException: Invalid end row index.\n\tat com.aspose.cells.e7u.a(Unknown Source)\n\tat com.aspose.cells.Cells.clearRange(Unknown Source)\n\tat com.aspose.cells.PivotTable.clearData(Unknown Source)\n\tat java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)\n\tat java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)\n\tat java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)\n\tat java.base/java.lang.reflect.Method.invoke(Method.java:569)\n\tat node.MethodCallBaton.invokeMethod9(MethodCallBaton.java:25)\n ",“time”:“2025-05-28T07:08:55.881Z”,“src”:{},“v”:0}

How to resolve please help

2

@vinaybabu
Would you like to provide sample files and executable test code? We will check it soon.