<%@ page import="org.apache.poi.hssf.usermodel.HSSFSheet"%> <%@ page import="org.apache.poi.hssf.usermodel.HSSFWorkbook"%> <%@ 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 import="org.apache.poi.hssf.usermodel.HSSFFont"%> <%@ 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"); HSSFFont font = hwb.createFont(); HSSFPatriarch patriarch = sheet.createDrawingPatriarch(); HSSFTextbox textbox1 = patriarch.createTextbox(new HSSFClientAnchor(0,0,0,0,(short)1,1,(short)2,2)); HSSFRichTextString string = new HSSFRichTextString("Rjaesh Kumar"); string.applyFont(2,5,font); textbox1.setString(string ); FileOutputStream fileOut = new FileOutputStream("c:\\excel\\setFontInBox.xls"); hwb.write(fileOut); fileOut.close(); out.println("Your excel file has been generated"); }catch ( Exception ex ){} %>