How to get pivot table sheet last fill row number using POI + Java. -version 3.12.x
<p>I have one Excel sheet which contains two sheets. One is a Data sheet and the second is a pivot sheet. </p>

<p>I have an issue while getting the last row number in the Excel sheet which  contains the pivot table.<br>
I am using -version 3.12.x poi.  </p>

<p>I tried <code>areaRef.getLastCell().getCol();</code>, <code>newSheet.getLastRowNum();</code> and <code>pivotTable.getDataSheet().getPhysicalNumberOfRows()</code> and other existing methods also. 
But I'm not getting the correct value. Its returning the Data sheet last number of record instead of pivot sheet.</p>

<p>Does anybody know how to get last fill row number in pivot table sheet?</p>