Package org.apache.poi.hssf.usermodel

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

199
200
201
202
203
204
205
206
207
208
    }

    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
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
  }

        HSSFCell c = getCell(row,column);
        if (c != null) {
          HSSFCellStyle s = c.getCellStyle();
          HSSFFont f = wb.getFontAt(s.getFontIndex());
          boolean isbold = f.getBoldweight() > HSSFFont.BOLDWEIGHT_NORMAL;
          boolean isitalics = f.getItalic();
//          System.out.println("bold="+isbold);
//          System.out.println("italics="+isitalics);
          int fontstyle = 0;

          if (isbold) fontstyle = Font.BOLD;
          if (isitalics) fontstyle = fontstyle | Font.ITALIC;

          int fontheight = f.getFontHeightInPoints();
          if (fontheight == 9) fontheight = 10; //fix for stupid ol Windows

//          System.out.println("fontsizeinpnts="+f.getFontHeightInPoints());

          Font font = new Font(f.getFontName(),fontstyle,fontheight);
          setFont(font);
         

          HSSFColor clr = null;
          if (s.getFillPattern() == HSSFCellStyle.SOLID_FOREGROUND) {
            clr = (HSSFColor)colors.get(new Integer(s.getFillForegroundColor()));
          }
          if (clr == null) clr = new HSSFColor.WHITE();

          short[] rgb = clr.getTriplet();
          Color awtcolor = new Color(rgb[0],rgb[1],rgb[2]);

          setBackground(awtcolor);

          clr = (HSSFColor)colors.get(new Integer(f.getColor()));
          if (clr == null) clr = new HSSFColor.BLACK();
          rgb = clr.getTriplet();
          awtcolor = new Color(rgb[0],rgb[1],rgb[2]);
          setForeground(awtcolor);
View Full Code Here
455
456
457
458
459
460
461
462
463
464
465
466
      gesamtkosten += jahrList.get(i).getJahrGesamtkosten();
    }
   
    myRow = mySheet.createRow(mySheet.getLastRowNum()+1);
   
    HSSFFont myFont = myWorkBook.createFont();
    myFont.setBoldweight(HSSFFont.BOLDWEIGHT_BOLD);
   
    HSSFCellStyle gesSumEuroCellStyle = myWorkBook.createCellStyle();
    gesSumEuroCellStyle.setDataFormat(myWorkBook.createDataFormat().getFormat("#,##0.00 �"));
    gesSumEuroCellStyle.setBorderBottom(HSSFCellStyle.BORDER_DOUBLE);
    gesSumEuroCellStyle.setBorderLeft(HSSFCellStyle.BORDER_THIN);
View Full Code Here
569
570
571
572
573
574
575
576
577
578
579
580
    myCell.setCellStyle(myCellStyle);
   
   
    myRow = mySheet.createRow(mySheet.getLastRowNum()+1);
   
    HSSFFont myFont = myWorkBook.createFont();
    myFont.setBoldweight(HSSFFont.BOLDWEIGHT_BOLD);
   
    HSSFCellStyle gesSumEuroCellStyle = myWorkBook.createCellStyle();
    gesSumEuroCellStyle.setDataFormat(myWorkBook.createDataFormat().getFormat("#,##0.00 �"));
    gesSumEuroCellStyle.setBorderBottom(HSSFCellStyle.BORDER_DOUBLE);
    gesSumEuroCellStyle.setBorderLeft(HSSFCellStyle.BORDER_THIN);
View Full Code Here
455
456
457
458
459
460
461
462
463
464
465
466
      gesamtkosten += jahrList.get(i).getJahrGesamtkosten();
    }
   
    myRow = mySheet.createRow(mySheet.getLastRowNum()+1);
   
    HSSFFont myFont = myWorkBook.createFont();
    myFont.setBoldweight(HSSFFont.BOLDWEIGHT_BOLD);
   
    HSSFCellStyle gesSumEuroCellStyle = myWorkBook.createCellStyle();
    gesSumEuroCellStyle.setDataFormat(myWorkBook.createDataFormat().getFormat("#,##0.00 �"));
    gesSumEuroCellStyle.setBorderBottom(HSSFCellStyle.BORDER_DOUBLE);
    gesSumEuroCellStyle.setBorderLeft(HSSFCellStyle.BORDER_THIN);
View Full Code Here
569
570
571
572
573
574
575
576
577
578
579
580
    myCell.setCellStyle(myCellStyle);
   
   
    myRow = mySheet.createRow(mySheet.getLastRowNum()+1);
   
    HSSFFont myFont = myWorkBook.createFont();
    myFont.setBoldweight(HSSFFont.BOLDWEIGHT_BOLD);
   
    HSSFCellStyle gesSumEuroCellStyle = myWorkBook.createCellStyle();
    gesSumEuroCellStyle.setDataFormat(myWorkBook.createDataFormat().getFormat("#,##0.00 �"));
    gesSumEuroCellStyle.setBorderBottom(HSSFCellStyle.BORDER_DOUBLE);
    gesSumEuroCellStyle.setBorderLeft(HSSFCellStyle.BORDER_THIN);
View Full Code Here
517
518
519
520
521
522
523
524
525
526
527
528
      gesamtkosten += monatList.get(i).getMonatGesamtkosten();
    }
   
    myRow = mySheet.createRow(mySheet.getLastRowNum()+1);
   
    HSSFFont myFont = myWorkBook.createFont();
    myFont.setBoldweight(HSSFFont.BOLDWEIGHT_BOLD);
   
    HSSFCellStyle gesSumEuroCellStyle = myWorkBook.createCellStyle();
    gesSumEuroCellStyle.setDataFormat(myWorkBook.createDataFormat().getFormat("#,##0.00 �"));
    gesSumEuroCellStyle.setBorderBottom(HSSFCellStyle.BORDER_DOUBLE);
    gesSumEuroCellStyle.setBorderLeft(HSSFCellStyle.BORDER_THIN);
View Full Code Here
592
593
594
595
596
597
598
599
600
601
602
603
    myCellStyle.setBorderTop(HSSFCellStyle.BORDER_MEDIUM);
    myCell.setCellStyle(myCellStyle);
   
    myRow = mySheet.createRow(mySheet.getLastRowNum()+1);
   
    HSSFFont myFont = myWorkBook.createFont();
    myFont.setBoldweight(HSSFFont.BOLDWEIGHT_BOLD);
   
    HSSFCellStyle gesSumEuroCellStyle = myWorkBook.createCellStyle();
    gesSumEuroCellStyle.setDataFormat(myWorkBook.createDataFormat().getFormat("#,##0.00 �"));
    gesSumEuroCellStyle.setBorderBottom(HSSFCellStyle.BORDER_DOUBLE);
    gesSumEuroCellStyle.setBorderLeft(HSSFCellStyle.BORDER_THIN);
View Full Code Here
455
456
457
458
459
460
461
462
463
464
465
466
      gesamtkosten += jahrList.get(i).getJahrGesamtkosten();
    }
   
    myRow = mySheet.createRow(mySheet.getLastRowNum()+1);
   
    HSSFFont myFont = myWorkBook.createFont();
    myFont.setBoldweight(HSSFFont.BOLDWEIGHT_BOLD);
   
    HSSFCellStyle gesSumEuroCellStyle = myWorkBook.createCellStyle();
    gesSumEuroCellStyle.setDataFormat(myWorkBook.createDataFormat().getFormat("#,##0.00 �"));
    gesSumEuroCellStyle.setBorderBottom(HSSFCellStyle.BORDER_DOUBLE);
    gesSumEuroCellStyle.setBorderLeft(HSSFCellStyle.BORDER_THIN);
View Full Code Here
569
570
571
572
573
574
575
576
577
578
579
580
    myCell.setCellStyle(myCellStyle);
   
   
    myRow = mySheet.createRow(mySheet.getLastRowNum()+1);
   
    HSSFFont myFont = myWorkBook.createFont();
    myFont.setBoldweight(HSSFFont.BOLDWEIGHT_BOLD);
   
    HSSFCellStyle gesSumEuroCellStyle = myWorkBook.createCellStyle();
    gesSumEuroCellStyle.setDataFormat(myWorkBook.createDataFormat().getFormat("#,##0.00 �"));
    gesSumEuroCellStyle.setBorderBottom(HSSFCellStyle.BORDER_DOUBLE);
    gesSumEuroCellStyle.setBorderLeft(HSSFCellStyle.BORDER_THIN);
View Full Code Here
TOP

Related Classes of org.apache.poi.hssf.usermodel.HSSFFont

  • AlMaGe.export.ExcelReportDreiJahre
  • AlMaGe.export.ExcelReportFuenfJahre
  • AlMaGe.export.ExcelReportJahr
  • AlMaGe.export.ExcelReportMonat
  • AlMaGe.export.ExcelReportQuartal
  • AlMaGe.export.ExcelReportZehnJahre
  • bg.smoc.model.web.ResultsStyle
  • br.net.woodstock.rockframework.document.spreadsheet.poi.HSSFSpreadsheetDocumentWriter
  • br.net.woodstock.rockframework.office.spreadsheet.poi.HSSFSpreadsheetDocumentWriter
  • com.aesthete.swingobjects.fw.common.util.ExcelHelper
    • Copyright © 2018 www.massapicom. All rights reserved.
    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.