We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

How to remove blank column & row From Pivot table using java


i created pivot table using aspose java code.how i can remove blank column & row From Pivot table using aspose java code.For this i am using below code but still not working.
sheet2.getCells().deleteBlankColumns();
sheet2.getCells().deleteBlankRows();

Hi,

Thank you for contacting Aspose support.

If your Pivot Table is based on a data source that contains blank rows & columns then your solution is correct, that is; you should be deleting the blank rows & columns from the worksheet having the data source for the Pivot Table, and then refresh/calculate the Pivot Table to make the changes take effect. In case you still face the difficulty, please give the scenario another try against the latest revision of the Aspose.Cells for Java 8.6.3.2 in order to make sure the problem is not version specific. If the latest release produces the same results then we require your input spreadsheet, an executable standalone sample application and resultant spreadsheet generated on your side to further investigate the matter on our end.