Examples of HSSFFont

org.apache.poi.hssf.usermodel.HSSFFont
Represents a Font used in a workbook. @version 1.0-pre @author Andrew C. Oliver @see org.apache.poi.hssf.usermodel.HSSFWorkbook#createFont() @see org.apache.poi.hssf.usermodel.HSSFWorkbook#getFontAt(short) @see org.apache.poi.hssf.usermodel.HSSFCellStyle#setFont(HSSFFont)

Examples of org.apache.poi.hssf.usermodel.HSSFFont

        HSSFRow          r      = null;
        HSSFCell         c      = null;
        HSSFCellStyle    cs     = wb.createCellStyle();
        HSSFCellStyle    cs2    = wb.createCellStyle();
        HSSFCellStyle    cs3    = wb.createCellStyle();
        HSSFFont         f      = wb.createFont();
        HSSFFont         f2     = wb.createFont();


        f.setFontHeightInPoints(( short ) 12);
        f.setColor(( short ) 0xA);
        f.setBoldweight(HSSFFont.BOLDWEIGHT_BOLD);
        f2.setFontHeightInPoints(( short ) 10);
        f2.setColor(( short ) 0xf);
        f2.setBoldweight(HSSFFont.BOLDWEIGHT_BOLD);
        cs.setFont(f);
        cs.setDataFormat(HSSFDataFormat.getBuiltinFormat("($#,##0_);[Red]($#,##0)"));
        cs2.setBorderBottom(HSSFCellStyle.BORDER_THIN);
        cs2.setFillPattern(( short ) 1);   // fill w fg
        cs2.setFillForegroundColor(( short ) 0xA);

View Full Code Here

Examples of org.apache.poi.hssf.usermodel.HSSFFont

    sheet.setColumnWidth(4, 6000);
    sheet.setColumnWidth(5, 1600);
    sheet.setColumnWidth(6, 20000);
    HSSFRow row = sheet.createRow(0);
    HSSFCellStyle style = wb.createCellStyle();
    HSSFFont font = wb.createFont();
    font.setBoldweight(HSSFFont.BOLDWEIGHT_BOLD);
    style.setFont(font);
    writeHeaderCell(row, 0, "Value", style);
    writeHeaderCell(row, 1, "Raw Long Bits", style);
    writeHeaderCell(row, 2, "JDK Double Rendering", style);
    writeHeaderCell(row, 3, "Actual Rendering", style);

View Full Code Here

Examples of org.apache.poi.hssf.usermodel.HSSFFont

    // -------------------------------------------------------- Private Methods


    private HSSFWorkbook createWorkbook() {
        HSSFWorkbook wb = new HSSFWorkbook();


        HSSFFont font = wb.createFont();
        font.setBoldweight(HSSFFont.BOLDWEIGHT_BOLD);


        HSSFSheet worksheet = wb.createSheet("Customers");
        worksheet.setColumnWidth((short) 0, (short)(20 * 256));
        worksheet.setColumnWidth((short) 1, (short)(30 * 256));
        worksheet.setColumnWidth((short) 4, (short)(20 * 256));


        HSSFRow row = worksheet.createRow((short)0);


        HSSFRichTextString value = new HSSFRichTextString("Customers");
        value.applyFont(font);
        row.createCell((short)0).setCellValue(value);


        row = worksheet.createRow((short)1);
        row.createCell((short)0).setCellValue(new HSSFRichTextString("Customer Account Details"));


        worksheet.createRow((short)2);


        row = worksheet.createRow((short)3);


        HSSFCellStyle style = wb.createCellStyle();
        style.setBorderBottom(HSSFCellStyle.BORDER_THIN);
        font = wb.createFont();
        font.setBoldweight(HSSFFont.BOLDWEIGHT_BOLD);


        value = new HSSFRichTextString("Name");
        value.applyFont(font);
        HSSFCell cell = row.createCell((short)0);
        cell.setCellValue(value);

View Full Code Here

Examples of org.apache.poi.hssf.usermodel.HSSFFont

    }


    protected HSSFCellStyle createHeaderStyle(HSSFSheet sheet) {
        HSSFCellStyle style = wb.createCellStyle();
        style.setBorderBottom(HSSFCellStyle.BORDER_THIN);
        HSSFFont font = wb.createFont();
        font.setBoldweight(HSSFFont.BOLDWEIGHT_BOLD);
        style.setFont(font);
        return style;
    }

View Full Code Here

Examples of org.apache.poi.hssf.usermodel.HSSFFont


    @SuppressWarnings("deprecation")
    private HSSFWorkbook createWorkbook() {
        HSSFWorkbook wb = new HSSFWorkbook();


        HSSFFont font = wb.createFont();
        font.setBoldweight(HSSFFont.BOLDWEIGHT_BOLD);


        HSSFSheet worksheet = wb.createSheet("Customers");
        worksheet.setColumnWidth(0, (20 * 256));
        worksheet.setColumnWidth(1, (30 * 256));
        worksheet.setColumnWidth(4, (20 * 256));


        HSSFRow row = worksheet.createRow(0);


        HSSFRichTextString value = new HSSFRichTextString("Customers");
        value.applyFont(font);
        row.createCell(0).setCellValue(value);


        row = worksheet.createRow(1);
        row.createCell(0).setCellValue(new HSSFRichTextString("Customer Account Details"));


        worksheet.createRow(2);


        row = worksheet.createRow(3);


        HSSFCellStyle style = wb.createCellStyle();
        style.setBorderBottom(HSSFCellStyle.BORDER_THIN);
        font = wb.createFont();
        font.setBoldweight(HSSFFont.BOLDWEIGHT_BOLD);


        value = new HSSFRichTextString("Name");
        value.applyFont(font);
        HSSFCell cell = row.createCell(0);
        cell.setCellValue(value);

View Full Code Here

Examples of org.apache.poi.hssf.usermodel.HSSFFont

    
    /**
     * create a font in the underlying HSSF model and return the reference
     */
    HSSFFont createFont() {
        HSSFFont font = _workbook.createFont();
       
        return font;
    }

View Full Code Here

Examples of org.apache.poi.hssf.usermodel.HSSFFont

  }


  private void handleCell(final HSSFWorkbook workbook, final HSSFRow row, final Cell cell, final int cellNum) {
    HSSFCell c = row.createCell(cellNum);


    HSSFFont font = workbook.createFont();
    font.setColor(this.getColor(workbook, cell.getFontColor()));
    font.setFontName(cell.getFont());
    font.setFontHeightInPoints((short) cell.getFontSize());


    if (cell.isBold()) {
      font.setBoldweight(Font.BOLDWEIGHT_BOLD);
    }


    if (cell.isItalic()) {
      font.setItalic(true);
    }


    if (cell.isStrikeout()) {
      font.setStrikeout(true);
    }


    if (cell.isUnderline()) {
      font.setUnderline(Font.U_SINGLE);
    }


    HSSFCellStyle style = workbook.createCellStyle();
    style.setAlignment(this.getAlignment(cell.getAlignment()));
    style.setVerticalAlignment(this.getVerticalAlignment(cell.getVerticalAlignment()));

View Full Code Here

Examples of org.apache.poi.hssf.usermodel.HSSFFont

    public ExcelUtils(List items, ItemSearch itemSearch) {
        this.wb = new HSSFWorkbook();
        this.sheet = wb.createSheet("jtrac");
        this.sheet.setDefaultColumnWidth((short) 12);
        
        HSSFFont fBold = wb.createFont();
        fBold.setBoldweight(HSSFFont.BOLDWEIGHT_BOLD);
        this.csBold = wb.createCellStyle();
        this.csBold.setFont(fBold);
        
        this.csDate = wb.createCellStyle();
        this.csDate.setDataFormat(HSSFDataFormat.getBuiltinFormat("m/d/yy"));

View Full Code Here

Examples of org.apache.poi.hssf.usermodel.HSSFFont

      cellStyle_timestamp.setDataFormat(HSSFDataFormat.getBuiltinFormat("m/d/yy h:mm"));


      HSSFCellStyle cellStyle_decimal = workbook.createCellStyle();
      cellStyle_decimal.setAlignment(HSSFCellStyle.ALIGN_RIGHT);


      HSSFFont font_title = workbook.createFont();
      font_title.setColor((short) 0xc);
      font_title.setBoldweight(HSSFFont.BOLDWEIGHT_BOLD);
      font_title.setItalic(true);
      font_title.setUnderline(HSSFFont.U_DOUBLE);
      cellStyle_title.setFont(font_title);


      HSSFCell cell;
      HSSFRow row;

View Full Code Here

Examples of org.apache.poi.hssf.usermodel.HSSFFont

      cellStyle_timestamp.setDataFormat(HSSFDataFormat.getBuiltinFormat("m/d/yy h:mm"));


      HSSFCellStyle cellStyle_decimal = workbook.createCellStyle();
      cellStyle_decimal.setAlignment(HSSFCellStyle.ALIGN_RIGHT);


      HSSFFont font_title = workbook.createFont();
      font_title.setColor((short) 0xc);
      font_title.setBoldweight(HSSFFont.BOLDWEIGHT_BOLD);
      font_title.setItalic(true);
      font_title.setUnderline(HSSFFont.U_DOUBLE);
      cellStyle_title.setFont(font_title);


      HSSFCell cell;
      HSSFRow row;

View Full Code Here

0 1 2 3 4 5

TOP

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.