Package org.apache.poi.xssf.usermodel

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

133
134
135
136
137
138
139
140
141
142
143
            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
441
442
443
444
445
446
447
448
449
450
451
    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
486
487
488
489
490
491
492
493
494
495
496
497
498
    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
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
            _inFormula = true;
        }
    }

    private void configureStyle(XSSFCellStyle style) {
        XSSFFont font = style.getFont();
        if (font.getBold()) {
            _style.bold();
        }
        if (font.getItalic()) {
            _style.italic();
        }
        if (font.getUnderline() != FontUnderline.NONE.getByteValue()) {
            _style.underline();
        }

        if (style.getFillPatternEnum() == FillPatternType.SOLID_FOREGROUND) {
            XSSFColor fillForegroundXSSFColor = style.getFillForegroundXSSFColor();
            String argb = fillForegroundXSSFColor.getARGBHex();
            if (argb != null) {
                _style.background(argb.substring(2));
            }
        }

        final XSSFFont stdFont = _stylesTable.getStyleAt(0).getFont();
        final short fontHeight = style.getFont().getFontHeightInPoints();
        if (stdFont.getFontHeightInPoints() != fontHeight) {
            _style.fontSize(fontHeight, SizeUnit.PT);
        }

        XSSFColor fontColor = style.getFont().getXSSFColor();
        if (fontColor != null) {
View Full Code Here
297
298
299
300
301
302
303
304
305
306
307
308
309
                    short[] triplet = color.getTriplet();
                    styleBuilder.foreground(triplet);
                }
            }
        } else if (font instanceof XSSFFont) {
            XSSFFont xssfFont = (XSSFFont) font;

            XSSFColor color = xssfFont.getXSSFColor();
            if (color != null) {
                String argbHex = color.getARGBHex();
                if (argbHex != null) {
                    styleBuilder.foreground(argbHex.substring(2));
                }
View Full Code Here
107
108
109
110
111
112
113
114
115
116
117
        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
384
385
386
387
388
389
390
391
392
393
394
        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
429
430
431
432
433
434
435
436
437
438
439
440
441
    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
115
116
117
118
119
120
121
122
123
124
125
        numberFormats.put((int)nfmt.getNumFmtId(), nfmt.getFormatCode());
      }
      if(doc.getStyleSheet().getFonts() != null){
        int idx = 0;
        for (CTFont font : doc.getStyleSheet().getFonts().getFontList()) {
          XSSFFont f = new XSSFFont(font, idx);
          fonts.add(f);
          idx++;
        }
      }
      if(doc.getStyleSheet().getFills() != null)
View Full Code Here
408
409
410
411
412
413
414
415
416
417
418
    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.