Package org.apache.poi.xssf.usermodel

Examples of org.apache.poi.xssf.usermodel.XSSFFont

453
454
455
456
457
458
459
460
461
462
463
464
465
    return ctFill;
  }

  private static XSSFFont createDefaultFont() {
    CTFont ctFont = CTFont.Factory.newInstance();
    XSSFFont xssfFont=new XSSFFont(ctFont, 0);
    xssfFont.setFontHeightInPoints(XSSFFont.DEFAULT_FONT_SIZE);
    xssfFont.setColor(XSSFFont.DEFAULT_FONT_COLOR);//setTheme
    xssfFont.setFontName(XSSFFont.DEFAULT_FONT_NAME);
    xssfFont.setFamily(FontFamily.SWISS);
    xssfFont.setScheme(FontScheme.MINOR);
    return xssfFont;
  }
View Full Code Here
696
697
698
699
700
701
702
703
704
705
706
707
708
709
710
711
712
713
714
715
716
717
718
719
720
721
722
723
724
725
726
727
728
729
730
731
732
733
734
735
736
737
738
739
740
741
742
743
744
745
746
747
748
749
750
751
752
753
754
755
756
757
758
759
760
761
762
763
764
        css(td,"background-color","#ffffff");
      }
    }
   
   
    XSSFFont font = style.getFont();
    if(font!=null){
      css(td,"font-family",font.getFontName());
      color = font.getXSSFColor();
      if(color!=null){
        CTColor ctColor = color.getCTColor();
        if(ctColor!=null){
          if(ctColor.isSetRgb()){
            byte[] rgb = ctColor.getRgb();
            if(rgb.length==3){
              if(rgb[0]==-1&&rgb[1]==-1&&rgb[2]==-1){
                css(td,"color","#000000");
              }else{
                css(td,"color",String.format("#%02x%02x%02x", rgb[0],rgb[1],rgb[2]));
              }
             
            }else if(rgb.length==4){
              if(rgb[1]==-1&&rgb[2]==-1&&rgb[3]==-1){
                css(td,"color","#000000");
              }else{
                css(td,"color",String.format("#%02x%02x%02x", rgb[1],rgb[2],rgb[3]));
              }
            }
          }else{
            css(td,"color","#000000");
          }
        }
      }else{
        css(td,"color","#000000");
      }
      css(td,"font-size",String.format("%dpx",pointsToPixels(font.getFontHeightInPoints())));
     
      // 20111024 对于
      // 1 styleLeft
      // 2 styleCenter
      // 3 styleRight
      // 和
      // 4 styleTop
      // 5 styleMiddle
      // 6 styleBottom 需要设置对应的td的valign和align属性
      // 7 styleBold
      // 8 styleItalics
      // 9 styleUnderline
      // 10 styleLineThrough
     
      if(XSSFFont.BOLDWEIGHT_BOLD==font.getBoldweight()){
        classes(td,"styleBold");
      }
      if(font.getItalic()){
        classes(td,"styleItalics"); 
      }
      switch(font.getUnderline()){
      case XSSFFont.U_DOUBLE:
      case XSSFFont.U_DOUBLE_ACCOUNTING:
      case XSSFFont.U_SINGLE:
      case XSSFFont.U_SINGLE_ACCOUNTING:
        classes(td,"styleUnderline");
      }
      if(font.getStrikeout()){
        classes(td,"styleLineThrough");
      }
    }else{
      css(td,"color","#000000");
    }
View Full Code Here
122
123
124
125
126
127
128
129
130
131
132
            CTFonts ctfonts = styleSheet.getFonts();
            if(ctfonts != null){
        int idx = 0;
        for (CTFont font : ctfonts.getFontArray()) {
           // Create the font and save it. Themes Table supplied later
          XSSFFont f = new XSSFFont(font, idx);
          fonts.add(f);
          idx++;
        }
      }
            CTFills ctfills = styleSheet.getFills();
View Full Code Here
451
452
453
454
455
456
457
458
459
460
461
    out.close();
  }

  private void initialize() {
    //CTFont ctFont = createDefaultFont();
    XSSFFont xssfFont = createDefaultFont();
    fonts.add(xssfFont);

    CTFill[] ctFill = createDefaultFills();
    fills.add(new XSSFCellFill(ctFill[0]));
    fills.add(new XSSFCellFill(ctFill[1]));
View Full Code Here
496
497
498
499
500
501
502
503
504
505
506
507
508
    return ctFill;
  }

  private static XSSFFont createDefaultFont() {
    CTFont ctFont = CTFont.Factory.newInstance();
    XSSFFont xssfFont=new XSSFFont(ctFont, 0);
    xssfFont.setFontHeightInPoints(XSSFFont.DEFAULT_FONT_SIZE);
    xssfFont.setColor(XSSFFont.DEFAULT_FONT_COLOR);//setTheme
    xssfFont.setFontName(XSSFFont.DEFAULT_FONT_NAME);
    xssfFont.setFamily(FontFamily.SWISS);
    xssfFont.setScheme(FontScheme.MINOR);
    return xssfFont;
  }
View Full Code Here
105
106
107
108
109
110
111
112
113
114
115
        numberFormats.put((int)nfmt.getNumFmtId(), nfmt.getFormatCode());
      }
      if(doc.getStyleSheet().getFonts() != null){
                int idx = 0;
                for (CTFont font : doc.getStyleSheet().getFonts().getFontArray()) {
                    XSSFFont f = new XSSFFont(font, idx);
                    fonts.add(f);
                    idx++;
                }
            }
      if(doc.getStyleSheet().getFills() != null)
View Full Code Here
382
383
384
385
386
387
388
389
390
391
392
        out.close();
    }

  private void initialize() {
    //CTFont ctFont = createDefaultFont();
    XSSFFont xssfFont = createDefaultFont();
    fonts.add(xssfFont);

    CTFill[] ctFill = createDefaultFills();
    fills.add(new XSSFCellFill(ctFill[0]));
    fills.add(new XSSFCellFill(ctFill[1]));
View Full Code Here
427
428
429
430
431
432
433
434
435
436
437
438
439
    return ctFill;
  }

  private static XSSFFont createDefaultFont() {
    CTFont ctFont = CTFont.Factory.newInstance();
    XSSFFont xssfFont=new XSSFFont(ctFont, 0);
    xssfFont.setFontHeightInPoints(XSSFFont.DEFAULT_FONT_SIZE);
    xssfFont.setColor(XSSFFont.DEFAULT_FONT_COLOR);//setTheme
    xssfFont.setFontName(XSSFFont.DEFAULT_FONT_NAME);
    xssfFont.setFamily(FontFamily.SWISS);
    xssfFont.setScheme(FontScheme.MINOR);
    return xssfFont;
  }
View Full Code Here
106
107
108
109
110
111
112
113
114
115
116
        numberFormats.put((int)nfmt.getNumFmtId(), nfmt.getFormatCode());
      }
      if(doc.getStyleSheet().getFonts() != null){
        int idx = 0;
        for (CTFont font : doc.getStyleSheet().getFonts().getFontArray()) {
          XSSFFont f = new XSSFFont(font, idx);
          fonts.add(f);
          idx++;
        }
      }
      if(doc.getStyleSheet().getFills() != null)
View Full Code Here
378
379
380
381
382
383
384
385
386
387
388
    out.close();
  }

  private void initialize() {
    //CTFont ctFont = createDefaultFont();
    XSSFFont xssfFont = createDefaultFont();
    fonts.add(xssfFont);

    CTFill[] ctFill = createDefaultFills();
    fills.add(new XSSFCellFill(ctFill[0]));
    fills.add(new XSSFCellFill(ctFill[1]));
View Full Code Here
TOP

Related Classes of org.apache.poi.xssf.usermodel.XSSFFont

  • br.net.woodstock.rockframework.document.spreadsheet.poi.XSSFSpreadsheetDocumentWriter
  • br.net.woodstock.rockframework.office.spreadsheet.poi.XSSFSpreadsheetDocumentWriter
  • cn.baiweigang.qtaf.ift.util.ExportReportExcel
  • com.narirelays.ems.utils.ExcelUtility
  • org.apache.metamodel.excel.ExcelUtils
  • org.apache.metamodel.excel.XlsxSheetToRowsHandler
  • org.apache.poi.ss.usermodel.FontCharset
  • org.apache.poi.ss.usermodel.FontUnderline
  • org.apache.poi.xssf.model.StylesTable
  • org.apache.poi.xssf.model.TestThemesTable
    • 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.