Wiki
Clone wikiAspose for Apache POI / Working-with-Fonts
Apache POI SS
// 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);
Aspose.Cells
//Adding some value to cell Cell cell = cells.get("A1"); cell.setValue("This is Aspose test of fonts!"); //Setting the font name to "Times New Roman" Style style = cell.getStyle(); Font font = style.getFont(); font.setName("Courier New"); font.setSize(24); font.setBold(true); font.setUnderline(FontUnderlineType.SINGLE); font.setColor(Color.getBlue()); font.setStrikeout(true); //font.setSubscript(true); cell.setStyle(style);
Download Source Code
Updated