Examples of XSSFFont

org.apache.poi.xssf.usermodel.XSSFFont
Represents a font used in a workbook. @author Gisella Bronzetti
org.zkoss.poi.xssf.usermodel.XSSFFont

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

    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

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

        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

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

            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

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

    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

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

    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

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

        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

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

        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

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

    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

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

        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

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

    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

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.