private HSSFFont matchFont( Font matchFont ) { HSSFColor hssfColor = workbook.getCustomPalette() .findColor((byte)foreground.getRed(), (byte)foreground.getGreen(), (byte)foreground.getBlue()); if (hssfColor == null) hssfColor = workbook.getCustomPalette().findSimilarColor((byte)foreground.getRed(), (byte)foreground.getGreen(), (byte)foreground.getBlue()); boolean bold = (matchFont.getStyle() & Font.BOLD) != 0; boolean italic = (matchFont.getStyle() & Font.ITALIC) != 0; HSSFFont hssfFont = workbook.findFont(bold, hssfColor.getIndex(), (short)(matchFont.getSize() * 20), matchFont.getName(), italic, false, (short)0, (byte)0); if (hssfFont == null) { hssfFont = workbook.createFont(); hssfFont.setBold(bold); hssfFont.setColor(hssfColor.getIndex()); hssfFont.setFontHeight((short)(matchFont.getSize() * 20)); hssfFont.setFontName(matchFont.getName()); hssfFont.setItalic(italic); hssfFont.setStrikeout(false); hssfFont.setTypeOffset((short) 0); hssfFont.setUnderline((byte) 0); } return hssfFont; }
HSSFFont boldFont = workbook.createFont(); boldFont.setBoldweight(HSSFFont.BOLDWEIGHT_BOLD);
style.setFillPattern(HSSFCellStyle.SOLID_FOREGROUND); HSSFFont font = wb.createFont(); font.setColor(HSSFColor.RED.index); style.setFont(font);
protected void createFonts() { stdFont = wb.createFont(); boldFont = wb.createFont(); boldFont.setBold(true); }
FontsContainer(HSSFWorkbook workbook) { boldFont = workbook.createFont(); boldFont.setBoldweight(Font.BOLDWEIGHT_BOLD); } }
FontsContainer(HSSFWorkbook workbook) { headerFont = workbook.createFont(); headerFont.setBoldweight(Font.BOLDWEIGHT_BOLD); } }
protected void createCellStyle() { HSSFFont boldFont = wb.createFont(); boldFont.setBold(true); boldStyle = wb.createCellStyle(); boldStyle.setFont(boldFont); }
private static HSSFCellStyle createTextStyle(HSSFWorkbook wb) { HSSFFont plain = wb.createFont(); plain.setFontHeightInPoints((short)12); HSSFCellStyle textStyle = wb.createCellStyle(); textStyle.setFont(plain); return textStyle; }
private HSSFFont createAndSetFontStyle(HSSFWorkbook wb) { HSSFFont font = wb.createFont(); font.setFontName(XSSFFont.DEFAULT_FONT_NAME); font.setBoldweight(XSSFFont.BOLDWEIGHT_BOLD); font.setFontHeightInPoints((short)10); return font; } HSSFCellStyle cellStyle = workBook.createCellStyle(); HSSFFont createfont = createAndSetFontStyle(workBook); cellStyle.setFont(createfont); cell.setCellStyle(cellStyle);
private static HSSFCellStyle createKeyStyle(HSSFWorkbook wb) { HSSFFont bold = wb.createFont(); bold.setBoldweight(HSSFFont.BOLDWEIGHT_BOLD); bold.setFontHeightInPoints((short)11); HSSFCellStyle keyStyle = wb.createCellStyle(); keyStyle.setFont(bold); return keyStyle; }
private static HSSFFont createCustomFont(short colorIndex, Byte underlineWeight) { HSSFFont font = wb1.createFont(); font.setFontName(HSSFFont.FONT_ARIAL); font.setFontHeightInPoints((short) 10); font.setBoldweight(HSSFFont.BOLDWEIGHT_BOLD); font.setColor(colorIndex); font.setUnderline(underlineWeight); return font; }
private static HSSFCellStyle createCommentStyle(HSSFWorkbook wb) { HSSFFont commentFont = wb.createFont(); commentFont.setColor(HSSFColor.GREEN.index); commentFont.setItalic(true); commentFont.setFontHeightInPoints((short)12); HSSFCellStyle commentStyle = wb.createCellStyle(); commentStyle.setFont(commentFont); return commentStyle; }
private static HSSFCellStyle createPlurarStyle(HSSFWorkbook wb) { HSSFFont commentFont = wb.createFont(); commentFont.setColor(HSSFColor.GREY_50_PERCENT.index); commentFont.setItalic(true); commentFont.setFontHeightInPoints((short)12); HSSFCellStyle commentStyle = wb.createCellStyle(); commentStyle.setFont(commentFont); return commentStyle; }
private HSSFCellStyle createHeaderStyle(){ //TO-DO read style information from sakai.properties HSSFFont font = gradesWorkbook.createFont(); font.setFontName(HSSFFont.FONT_ARIAL); font.setColor(IndexedColors.PLUM.getIndex()); font.setBoldweight(HSSFFont.BOLDWEIGHT_BOLD); HSSFCellStyle cellStyle = gradesWorkbook.createCellStyle(); cellStyle.setFont(font); return cellStyle; }
HSSFWorkbook wb = new HSSFWorkbook(); HSSFSheet sheet = wb.createSheet("New sheet"); HSSFFont font = wb.createFont(); font.setFontName("Arial Unicode MS"); HSSFCellStyle style = wb.createCellStyle(); style.setFont(font); HSSFRow row = sheet.createRow((short) 0); HSSFCell cell = row.createCell((short) 0); cell.setEncoding(HSSFCell.ENCODING_UTF_16); cell.setCellStyle(style); cell.setCellValue("\u53f8");
HSSFFont font=wb.createFont(); font.setFontHeight((short)(cellStyle.getFontSize()*20)); Boolean bold=cellStyle.getBold();
private static HSSFCellStyle createTilteStyle(HSSFWorkbook wb) { HSSFFont bold = wb.createFont(); bold.setBoldweight(HSSFFont.BOLDWEIGHT_BOLD); HSSFCellStyle style = wb.createCellStyle(); style.setFont(bold); style.setFillForegroundColor(HSSFColor.GREY_25_PERCENT.index); style.setFillPattern(HSSFCellStyle.SOLID_FOREGROUND); style.setAlignment(HSSFCellStyle.ALIGN_CENTER); style.setWrapText(true); return style; }
private void createDefaultHeaderCellStyle() { headerCellStyle = workbook.createCellStyle(); HSSFFont font = workbook.createFont(); font.setBoldweight(HSSFFont.BOLDWEIGHT_BOLD); font.setColor(HSSFColor.WHITE.index); headerCellStyle.setFont(font); headerCellStyle .setFillBackgroundColor(HSSFColor.GREY_25_PERCENT.index); headerCellStyle.setFillPattern(HSSFCellStyle.FINE_DOTS); headerCellStyle.setBorderTop(HSSFCellStyle.BORDER_THIN); headerCellStyle.setBorderBottom(HSSFCellStyle.BORDER_THIN); }
public HSSFCellStyle style() { Font font = worksheet.getWorkbook().createFont(); font.setBoldweight(Font.BOLDWEIGHT_BOLD); font.setFontHeight((short) TITLE_FONT_HEIGHT); HSSFCellStyle cellStyle = worksheet.getWorkbook().createCellStyle(); cellStyle.setAlignment(alignment); cellStyle.setWrapText(true); cellStyle.setFont(font); return cellStyle; } }
private HSSFCellStyle createHeaderStyle(HSSFWorkbook myWorkBook) { Font headerFont = myWorkBook.createFont(); headerFont.setColor(Font.COLOR_NORMAL); HSSFPalette palette = myWorkBook.getCustomPalette(); HSSFColor headerColor = palette.findSimilarColor((byte) 149, (byte) 179, (byte) 215); HSSFCellStyle headerStyle = myWorkBook.createCellStyle(); headerStyle.setFillForegroundColor(headerColor.getIndex()); headerStyle.setFillPattern(CellStyle.SOLID_FOREGROUND); headerStyle.setFont(headerFont); headerStyle.setWrapText(true); return headerStyle; }