In this program we are going create a sheet and
then by use of createSplitPane() and createFreezePane() methods we split and
freeze the sheets.
The package we need to import is java.io.*,java.util.* ,org.apache.poi.hssf.usermodel.HSSFSheet, org.apache.poi.usermodel. HSSFPrintSetup and org.apache.poi.hssf.usermodel. HSSFWorkbook.
The org.apache.poi.hssf.usermodel.HSSFPrintSetup class is used to get print setup object.
In this example we have create four sheets and in first three sheets, we use freeze the pane in different ways and in last one we split the pane
The method used in this example shift row
createFreezePane(int colSplit,int rowSplit):
This method is defined as public and the return type of this method is void. This method is used creates a freezepane. There are two parameters passed in this method. The first one is colSplit and the second is rowSplit .The colSplit gives the horizonatal position of split and the rowSplit gives
the vertical position of split.
createFreezePane(int colSplit,int rowSplit,int leftmostColumn,int topRow):
In this method rest all are same except we pass here four parameters .These are colSplit for the horizonatal position of split,rowSplit for the vertical position of split,topRow for the top row visible in bottom pane and leftmostColumn for the left column visible in right pane.
createSplitPane(int xSplitPos,int ySplitPos,int
leftmostColumn,int topRow,int activePane):
This is used to create split pane into sheet. In this method we pass the five parameters.These are xSplitPos for the horizonatal position of split (the values will be in 1/20th of a point),ySplitPos for the vertical position of split (the values will be in 1/20th of a point),topRow for the top row visible in bottom pane,leftmostColumn for the left column visible in right paneand activePane this is used top Active Pane int type.It should be one of following:
The code of the program is given below:
The output of the program is given below:
Liked it! Share this Tutorial