<%@ 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("Rjaesh 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 ) { } %>