Apache POI Excel Font

by Online Tutorials Library July 14, 2022

Apache POI Excel Font

Apache POI provides methods to handle font in excel sheet. We can create font, set color, set size etc. The Font is an interface which provides methods to handle the font.

Lets see an example in which we are creating and setting new font for our cell content.

Apache POI Excel Cell Font Example

  package poiexample;  import java.io.FileOutputStream;  import java.io.OutputStream;  import org.apache.poi.hssf.usermodel.HSSFWorkbook;  import org.apache.poi.ss.usermodel.Cell;  import org.apache.poi.ss.usermodel.CellStyle;  import org.apache.poi.ss.usermodel.Font;  import org.apache.poi.ss.usermodel.Row;  import org.apache.poi.ss.usermodel.Sheet;  import org.apache.poi.ss.usermodel.Workbook;  public class FontExample {  public static void main(String[] args) {  try (OutputStream fileOut = new FileOutputStream(“tutoraspire.xls”)) {  Workbook wb = new HSSFWorkbook(); // Creating a workbook  Sheet sheet = wb.createSheet(“Sheet”); // Creating a sheet  Row row = sheet.createRow(1); // Creating a row  Cell cell = row.createCell(1); // Creating a cell  CellStyle style = wb.createCellStyle(); // Creating Style  cell.setCellValue(“Hello, tutoraspire!”);  // Creating Font and settings  Font font = wb.createFont();  font.setFontHeightInPoints((short)11);  font.setFontName(“Courier New”);  font.setItalic(true);  font.setStrikeout(true);  // Applying font to the style  style.setFont(font);  // Applying style to the cell  cell.setCellStyle(style);              wb.write(fileOut);      }catch(Exception e) {      System.out.println(e.getMessage());      }  }  }  

Output:

Next TopicApache POI Excel Header

Apache POI Excel Font

Apache POI Excel Font

Apache POI Excel Cell Font Example

Apache Cordova Tutorial

Updating the Document Using XML in Apache Solr

You may also like