Latest Tutorials| Questions and Answers|Ask Questions?|Site Map



Home Jsp Poi Freeze And Split Pane

Related Tutorials


 
 

Share on Google+Share on Google+

Freeze And Split Pane

Advertisement
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

     

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.

Advertisements

If you enjoyed this post then why not add us on Google+? Add us to your Circles



Liked it!  Share this Tutorial


Follow us on Twitter, or add us on Facebook or Google Plus to keep you updated with the recent trends of Java and other open source platforms.

Posted on: May 19, 2007

Related Tutorials

Discuss: Freeze And Split Pane  

Post your Comment


Your Name (*) :
Your Email :
Subject (*):
Your Comment (*):
  Reload Image
 
 
Comments:1
s
March 23, 2012
thanks

very useful
DMCA.com