List of usage examples for org.apache.poi.hssf.usermodel HSSFFont getBold
public boolean getBold()
From source file:org.bbreak.excella.core.test.util.TestUtil.java
License:Open Source License
private static String getHSSFFontString(HSSFWorkbook workbook, HSSFFont font) { StringBuffer sb = new StringBuffer(); sb.append("[FONT]"); sb.append("fontheight=").append(Integer.toHexString(font.getFontHeight())).append(","); sb.append("italic=").append(font.getItalic()).append(","); sb.append("strikout=").append(font.getStrikeout()).append(","); sb.append("colorpalette=").append(getHSSFColorString((HSSFWorkbook) workbook, font.getColor())).append(","); sb.append("boldweight=").append(font.getBold()).append(","); sb.append("supersubscript=").append(Integer.toHexString(font.getTypeOffset())).append(","); sb.append("underline=").append(Integer.toHexString(font.getUnderline())).append(","); sb.append("charset=").append(Integer.toHexString(font.getCharSet())).append(","); sb.append("fontname=").append(font.getFontName()); sb.append("[/FONT]"); return sb.toString(); }
From source file:org.bbreak.excella.reports.ReportsTestUtil.java
License:Open Source License
/** * HSSF????/* w ww. ja v a 2s . com*/ * * @param workbook * @param font * @return ?? */ private static String getHSSFFontString(HSSFWorkbook workbook, HSSFFont font) { StringBuffer sb = new StringBuffer(); sb.append("[FONT]"); sb.append("fontheight=").append(Integer.toHexString(font.getFontHeight())).append(","); sb.append("italic=").append(font.getItalic()).append(","); sb.append("strikout=").append(font.getStrikeout()).append(","); sb.append("colorpalette=").append(getHSSFColorString((HSSFWorkbook) workbook, font.getColor())).append(","); sb.append("bold=").append(font.getBold()).append(","); sb.append("supersubscript=").append(Integer.toHexString(font.getTypeOffset())).append(","); sb.append("underline=").append(Integer.toHexString(font.getUnderline())).append(","); sb.append("charset=").append(Integer.toHexString(font.getCharSet())).append(","); sb.append("fontname=").append(font.getFontName()); sb.append("[/FONT]"); return sb.toString(); }
From source file:org.sysmodb.xml.HSSFXMLStyleHelper.java
License:BSD License
public boolean areFontsEmpty(CellStyle style) { HSSFCellStyle newStyle = (HSSFCellStyle) style; HSSFFont font = newStyle.getFont(workbook); if (font.getBold()) return false; if (font.getItalic()) return false; if (font.getUnderline() != HSSFFont.U_NONE) return false; // Ignore same-ish defaults if (font.getFontHeightInPoints() != 10 && font.getFontHeightInPoints() != 11) return false; // Arial is default for Excel, Calibri is default for OO if (!font.getFontName().equals("Arial") && !font.getFontName().equals("Calibri")) return false; if ((font.getColor() != HSSFFont.COLOR_NORMAL) && (getRGBString(font.getColor()) != null) && !getRGBString(font.getColor()).equals("#000")) return false; return true;/*from w ww .ja va 2s .c o m*/ }
From source file:org.sysmodb.xml.HSSFXMLStyleHelper.java
License:BSD License
@Override public void writeFontProperties(XMLStreamWriter xmlWriter, CellStyle style) throws XMLStreamException { HSSFCellStyle newStyle = (HSSFCellStyle) style; HSSFFont font = newStyle.getFont(workbook); if (font.getBold()) { xmlWriter.writeStartElement("font-weight"); xmlWriter.writeCharacters("bold"); xmlWriter.writeEndElement();//from w w w .j a v a2 s. c o m } if (font.getItalic()) { xmlWriter.writeStartElement("font-style"); xmlWriter.writeCharacters("italics"); xmlWriter.writeEndElement(); } if (font.getUnderline() != HSSFFont.U_NONE) { xmlWriter.writeStartElement("text-decoration"); xmlWriter.writeCharacters("underline"); xmlWriter.writeEndElement(); } // Ignore same-ish defaults if (font.getFontHeightInPoints() != 10 && font.getFontHeightInPoints() != 11) { xmlWriter.writeStartElement("font-size"); xmlWriter.writeCharacters(String.valueOf(font.getFontHeightInPoints() + "pt")); xmlWriter.writeEndElement(); } // Arial is default for Excel, Calibri is default for OO if (!font.getFontName().equals("Arial") && !font.getFontName().equals("Calibri")) { xmlWriter.writeStartElement("font-family"); xmlWriter.writeCharacters(font.getFontName()); xmlWriter.writeEndElement(); } if ((font.getColor() != HSSFFont.COLOR_NORMAL) && (getRGBString(font.getColor()) != null) && !getRGBString(font.getColor()).equals("#000")) { xmlWriter.writeStartElement("color"); xmlWriter.writeCharacters(getRGBString(font.getColor())); xmlWriter.writeEndElement(); } }