POI api Projects

POI api Project 1

Working with fonts using POI
Previous Home Next


In this page of the example we are try to show you how you can work on the font of the text which is stored into the workbook of sheet. for performing this task POI provide the Font feature. we can instantiate the font object in our class and use it to set the font of text.  

 Firstly we are instantiated to the Workbook then create the sheet using creatSheet() method into the workbook. and the next step is to create the row under the sheet by createRow() method. and then call the font to set the font name, style, size etc.

Workbook wb =
new HSSFWorkbook(); Sheet sheet = wb.createSheet("new sheet"); // Create a row and put some cells in it. Rows are 0 based. Row row = sheet.createRow(1); // Create a new font and alter it. Font font = wb.createFont(); font.setFontHeightInPoints((short)24); font.setFontName("Courier New"); font.setItalic(true); font.setStrikeout(true); // Fonts are set into a style so create a new one to use. CellStyle style = wb.createCellStyle(); style.setFont(font); // Create a cell and put a value in it. Cell cell = row.createCell(1); cell.setCellValue("This is a test of fonts"); cell.setCellStyle(style); // Write the output to a file FileOutputStream fileOut = new FileOutputStream("workbook.xls"); wb.write(fileOut); fileOut.close();


Previous Home Next