Package org.apache.poi.ss.usermodel

Examples of org.apache.poi.ss.usermodel.Font

66
67
68
69
70
71
72
73
74
75
76
    // Funny one: Please note that the layout will be broken if the first
    // font is not 'Arial 10'.
    final short numberOfFonts = this.workbook.getNumberOfFonts();
    for (int i = 0; i < numberOfFonts; i++)
    {
      final Font font = workbook.getFontAt((short) i);
      this.fonts.put(new HSSFFontWrapper(font), font);
    }

    // add the default font
    // this MUST be the first one, that is created.
View Full Code Here
97
98
99
100
101
102
103
104
105
    {
      return (Font) fonts.get(wrapper);
    }

    // ok, we need a new one ...
    final Font excelFont = createFont(wrapper);
    fonts.put(wrapper, excelFont);
    return excelFont;
  }
View Full Code Here
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
   * @param wrapper the font wrapper that holds all font information from the repagination.
   * @return the created font.
   */
  private Font createFont(final HSSFFontWrapper wrapper)
  {
    final Font font = workbook.createFont();
    if (wrapper.isBold())
    {
      font.setBoldweight(Font.BOLDWEIGHT_BOLD);
    }
    else
    {
      font.setBoldweight(Font.BOLDWEIGHT_NORMAL);
    }
    font.setColor(wrapper.getColorIndex());
    font.setFontName(wrapper.getFontName());
    font.setFontHeightInPoints((short) wrapper.getFontHeight());
    font.setItalic(wrapper.isItalic());
    font.setStrikeout(wrapper.isStrikethrough());
    if (wrapper.isUnderline())
    {
      font.setUnderline(Font.U_SINGLE);
    }
    else
    {
      font.setUnderline(Font.U_NONE);
    }
    return font;
  }
View Full Code Here
189
190
191
192
193
194
195
196
197
198
199
200
        final boolean italic = styleSheet.getBooleanStyleProperty(TextStyleKeys.ITALIC);
        final boolean underline = styleSheet.getBooleanStyleProperty(TextStyleKeys.UNDERLINED);
        final boolean strikethrough = styleSheet.getBooleanStyleProperty(TextStyleKeys.STRIKETHROUGH);
        final HSSFFontWrapper wrapper = new HSSFFontWrapper
            (fontName, fontSize, bold, italic, underline, strikethrough, fontColorProducer.getNearestColor(textColor));
        final Font excelFont = fontFactory.getExcelFont(wrapper);
        this.font = excelFont.getIndex();

        final ElementAlignment horizontal =
            (ElementAlignment) styleSheet.getStyleProperty(ElementStyleKeys.ALIGNMENT);
        this.horizontalAlignment = HSSFCellStyleProducer.convertAlignment(horizontal);
        final ElementAlignment vertical =
View Full Code Here
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
          int startingFonts = initialFonts[i];
         
          assertEquals(startingFonts, wb.getNumberOfFonts());
         
          // Get a font, and slightly change it
          Font a = wb.createFont();
          assertEquals(startingFonts+1, wb.getNumberOfFonts());
          a.setFontHeightInPoints((short)23);
          assertEquals(startingFonts+1, wb.getNumberOfFonts());
         
          // Get two more, unchanged
          Font b = wb.createFont();
          assertEquals(startingFonts+2, wb.getNumberOfFonts());
          Font c = wb.createFont();
          assertEquals(startingFonts+3, wb.getNumberOfFonts());
       }
    }
View Full Code Here
804
805
806
807
808
809
810
811
812
813
814
815
816
817
818
          "This line finishes with two trailing spaces.  ";
      
       XSSFWorkbook wb = new XSSFWorkbook();
       XSSFSheet sheet = wb.createSheet();

       Font font1 = wb.createFont();
       font1.setColor((short) 20);
       Font font2 = wb.createFont();
       font2.setColor(Font.COLOR_RED);
       Font font3 = wb.getFontAt((short)0);

       XSSFRow row = sheet.createRow(2);
       XSSFCell cell = row.createCell(2);

       XSSFRichTextString richTextString =
View Full Code Here
60
61
62
63
64
65
66
67
68
69
70
            throw new IllegalArgumentException("workbook must not be null"); //$NON-NLS-1$
        }
        this.workbook = workbook;
        this.version = WorkbookGenerator.getSpreadsheetVersion(workbook);

        Font font = workbook.createFont();
        // font.setFontName("ＭＳ ゴシック");

        commonStyle = workbook.createCellStyle();
        commonStyle.setFont(font);
        commonStyle.setBorderTop(CellStyle.BORDER_THIN);
View Full Code Here
51
52
53
54
55
56
57
58
59
60
61
        if (workbook == null) {
            throw new IllegalArgumentException("workbook must not be null"); //$NON-NLS-1$
        }
        this.workbook = workbook;

        Font font = workbook.createFont();
        // font.setFontName("ＭＳ ゴシック");

        commonStyle = workbook.createCellStyle();
        commonStyle.setFont(font);
        commonStyle.setBorderTop(CellStyle.BORDER_THIN);
View Full Code Here
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
            return Style.NO_STYLE;
        }
        final CellStyle cellStyle = cell.getCellStyle();

        final short fontIndex = cellStyle.getFontIndex();
        final Font font = workbook.getFontAt(fontIndex);
        final StyleBuilder styleBuilder = new StyleBuilder();

        // Font bold, italic, underline
        if (font.getBoldweight() >= Font.BOLDWEIGHT_BOLD) {
            styleBuilder.bold();
        }
        if (font.getItalic()) {
            styleBuilder.italic();
        }
        if (font.getUnderline() != FontUnderline.NONE.getByteValue()) {
            styleBuilder.underline();
        }

        // Font size
        final Font stdFont = workbook.getFontAt((short) 0);
        final short fontSize = font.getFontHeightInPoints();
        if (stdFont.getFontHeightInPoints() != fontSize) {
            styleBuilder.fontSize(fontSize, SizeUnit.PT);
        }

        // Font color
        final short colorIndex = font.getColor();
View Full Code Here
66
67
68
69
70
71
72
73
74
75
76
    // Funny one: Please note that the layout will be broken if the first
    // font is not 'Arial 10'.
    final short numberOfFonts = this.workbook.getNumberOfFonts();
    for (int i = 0; i < numberOfFonts; i++)
    {
      final Font font = workbook.getFontAt((short) i);
      this.fonts.put(new HSSFFontWrapper(font), font);
    }

    // add the default font
    // this MUST be the first one, that is created.
View Full Code Here
TOP

Related Classes of org.apache.poi.ss.usermodel.Font

  • accounts.web.ReportPoiController
  • accounts.web.ReportPoiControllerTest
  • bad.robot.excel.style.ReplaceExistingStyle
  • br.com.objectos.way.io.TableStyle
  • com.asakusafw.testdata.generator.excel.WorkbookInfo
  • com.asakusafw.testdriver.excel.WorkbookInfo
  • com.dtrules.compiler.excel.util.Rules2Excel
  • com.ebay.xcelite.styles.CellStyles
  • com.gd.sdr.dao.UserDAO
  • com.gd.sdr.dao.UserDAO1
    • 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.