How to get the last column of a pivot table table using POI + Java. version 3.12.x

Question

I have one excel sheet that contains two sheets. One of them is a data sheet, and the second is a summary sheet.

I have a problem getting the last row number in an Excel worksheet that contains a pivot table.
I am using -version 3.12.x poi.

I tried areaRef.getLastCell().getCol();, newSheet.getLastRowNum();and pivotTable.getDataSheet().getPhysicalNumberOfRows()other existing methods. But I do not get the correct value. Its returning the Data Data of the last record number instead of the pivot table.

Does anyone know how to get the last fill line number in a pivot table tables?

Answer 1

. , , .