[an error occurred while processing this directive]

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.io.*,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:

1.HSSFRichTextString()

2.HSSFRichTextString(java.lang.String string) 

The 
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. 

createDrawingPatriarch(): 
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/vnd.ms-excel" %>
<%page import="java.io.*" %>
<%page import="java.util.*" %>
<%
try{
  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
(
"c:\\excel\\createBox.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.

                         

[an error occurred while processing this directive]