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.createFreezePane( 0, 1, 0, 1 );
sheet2.createFreezePane( 1, 0, 1, 0 );
sheet3.createFreezePane( 2, 2 );
sheet4.createSplitPane( 2000, 2000, 0, 0, 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.
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Current Comments
0 comments so far (post your own) View All Comments Latest 10 Comments: