Home Jsp Poi Create Box in Excel Sheet Using JSP

Create Box in Excel Sheet Using JSP
Posted on: May 19, 2007 at 12:00 AM

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

Related Tags for Create Box in Excel Sheet Using JSP:
java, c, apache, string, com, class, unicode, text, static, textbox, import, model, constructor, fonts, object, setup, io, struct, client, user, sed, print, word, font, const, port, key, anchor, cli, int, ria, package, set, tar, oo, app, simple, tex, boo, for, poi, ie, box, bit, keyword, work, book, to, extend, mode, lan, sh, ext, bi, e, il, shape, it, extends, can, li, use, short, pe, im, art, comparable, in, java.io, no, mod, rm, sha, part, as, sta, m, nt, par, tr, sheet, nic, ca, nic, j, pack, arc, cl, es, em, end, age, rc, ico, me, obj, pp, parts, ack, fs, tor, s, rich, del, ctor, ee, at, pac, k, is, ha, iar, mpl, and, arts, ar, stat, cod, code, cons, str, richtext, rt, rts, sim, xt, util, usermode, va, uti, tw, s, s, ri, ring, rd, tbo, th, sho, av, st, .com, ab, abl, arb, ati, ap, hat, cto, ends, fsi, ends, kb, je, hssf, org, ple, pl, pr, nd, ode, on, om, o

«Previous Index Next»