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"%>
|
The output of the program is given below: