Create Box in Excel Sheet Using JSP

In this program we are going create a box and then after we pass the sting in the box.

create box in excel sheet using jsp


In this program we are going create a box  and then after we pass the sting in the box.
Code description

The package we need to import is*,java.util.* ,org.apache.poi.hssf.usermodel.HSSFSheet, org.apache.poi.hssf.usermodel. HSSFPrintSetup, org.apache.poi.hssf.usermodel.HSSFTextbox, org.apache.poi.hssf.usermodel.HSSFRichTextString, org.apache.poi.hssf.usermodel.HSSFPatriarch, org.apache.poi.hssf.usermodel.HSSFClientAnchor, org.apache. poi.hssf.usermodel. HSSFSimpleShape and org.apache.poi.hssf.usermodel. HSSFWorkbook.
The org.apache.poi.hssf.usermodel.HSSFRichTextString class extends extends java.lang.Object and implements java.lang.Comparable.The 
rich text unicode string and  can have fonts applied to arbitary parts of the string. There is a static short keyword  NO_FONT is used that there is no font can applied.
There are two constructor for HSSFRichTextString:


2.HSSFRichTextString(java.lang.String string) 

org.apache.poi.hssf.usermodel.HSSFSimpleShape class is extended by org.apache.poi.hssf.usermodel.HSSFTextbox class and the org.apache.poi.hssf.usermodel.HSSFTextbox class is extends HSSFSimpleShape.A textbox is a shape that may hold a rich text string. 

This method is used to creates a top level drawing patriarch.

createTextbox(HSSFChildAnchor anchor):
This method is used to create a new textbox under the group.

In this example we are creating a sheet then after we create aobject of patriarch after that we create textbox and at last we set string into created box. 
 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 import="org.apache.poi.hssf.usermodel.HSSFPatriarch"%>
<%page import="org.apache.poi.hssf.usermodel.HSSFClientAnchor"%>
<%page import="org.apache.poi.hssf.usermodel.HSSFTextbox"%>
<%page import="org.apache.poi.hssf.usermodel.HSSFRichTextString"%>
<%page contentType="application/" %>
<%page import="*" %>
<%page import="java.util.*" %>
  HSSFWorkbook hwb = new HSSFWorkbook();
  HSSFSheet sheet = hwb.createSheet("new sheet");
  HSSFPatriarch patriarch = sheet.createDrawingPatriarch();
  HSSFTextbox textbox1 = patriarch.createTextbox
new HSSFClientAnchor(0,0,0,0,(short)1,1,(short)2,2));
  textbox1.setString(new HSSFRichTextString("Rajesh Kumar") );
  FileOutputStream fileOut = new FileOutputStream
  out.println("Your excel file has been generated");
 catch Exception ex ) {

The output of the program is given below:

Download this example.




We have 1000s of tutorials on our website. Search Tutorials tutorials on our website.

Share on Google+Share on Google+

Create Box in Excel Sheet Using JSP

Posted on: May 19, 2007 If you enjoyed this post then why not add us on Google+? Add us to your Circles



Discuss: Create Box in Excel Sheet Using JSP   View All Comments

Post your Comment

Your Name (*) :
Your Email :
Subject (*):
Your Comment (*):
  Reload Image