Freeze And Split Pane

In this program we are going create a sheet and then by use of createSplitPane() and createFreezePane() methods we split and freeze the sheets.

Freeze And Split Pane

freeze and split pane

     

In this program we are going create a sheet  and then by use of createSplitPane() and createFreezePane() methods we split and freeze the sheets.

Code description 
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:
 PANE_LOWER_RIGHT
 PANE_UPPER_RIGHT
 PANE_LOWER_LEFT
 PANE_UPPER_LEFT
 PANE_LOWER_LEFT
 PANE_LOWER_RIGHT
 PANE_UPPER_LEFT
 PANE_UPPER_RIGHT


 The code of the program is given below:

<%page import="org.apache.poi.hssf.usermodel.HSSFSheet"%>
<%page import="org.apache.poi.hssf.usermodel.HSSFWorkbook"%>
<%page import="org.apache.poi.hssf.usermodel.HSSFPrintSetup"%>
<%page contentType="application/vnd.ms-excel" %>
<%page import="java.io.*" %>
<%page import="java.util.*" %>
<%
try{
  HSSFWorkbook hwb = new HSSFWorkbook();
  HSSFSheet sheet1 = hwb.createSheet("new sheet");
  HSSFSheet sheet2 = hwb.createSheet("second sheet");
  HSSFSheet sheet3 = hwb.createSheet("thrid sheet");
  HSSFSheet sheet4 = hwb.createSheet("four sheet");
  sheet1.createFreezePane010);
  sheet2.createFreezePane101);
  sheet3.createFreezePane2);
  sheet4.createSplitPane2000200000, HSSFSheet.PANE_LOWER_LEFT );
  FileOutputStream fileOut = new FileOutputStream
(
"c:\\excel\\freezeSplitPane.xls");
  hwb.write(fileOut);
  fileOut.close();
  out.println("Your excel file has been generated");
  catch Exception ex ) {
 
  }
%>

The output of the program is given below:

Download this example.