When I tried with above code I got below exception:
Invalid parameters of freeze panes
java.lang.IllegalArgumentException: Invalid parameters of freeze panes
at com.aspose.cells.F.a(Unknown Source)
at com.aspose.cells.Worksheet.freezePanes(Unknown Source)
Api Version: aspose-cells.220.127.116.11
Sorry to missing below requirement:
While Loading the formate from DB. I deleting 3 to 6 rows using below code.
Cells cells = sheet.getCells();
cells.deleteRows(3, 6, true); // So it will delete 4 to 6 rows
those columns contain some unwanted data, So I have to delete while loading. After deleting we are filling the data to templat.