Package org.apache.poi.hssf.usermodel

Examples of org.apache.poi.hssf.usermodel.HSSFWorkbook.createFont()

36
37
38
39
40
41
42
43
44
45
46
        CellStyle cs2 = wb.createCellStyle();
        CellStyle cs3 = wb.createCellStyle();
        DataFormat df = wb.createDataFormat();
        // create 2 fonts objects
        Font f = wb.createFont();
        Font f2 = wb.createFont();

        //set font 1 to 12 point type
        f.setFontHeightInPoints((short) 12);
        //make it blue
        f.setColor((short) 0xc);
View Full Code Here
87
88
89
90
91
92
93
94
95
96
97
        HSSFRow          r      = null;
        HSSFCell         c      = null;
        HSSFCellStyle    cs     = wb.createCellStyle();
        HSSFCellStyle    cs2    = wb.createCellStyle();
        HSSFCellStyle    cs3    = wb.createCellStyle();
        HSSFFont         f      = wb.createFont();
        HSSFFont         f2     = wb.createFont();

        f.setFontHeightInPoints(( short ) 12);
        f.setColor(( short ) 0xA);
        f.setBoldweight(HSSFFont.BOLDWEIGHT_BOLD);
View Full Code Here
88
89
90
91
92
93
94
95
96
97
98
        HSSFCell         c      = null;
        HSSFCellStyle    cs     = wb.createCellStyle();
        HSSFCellStyle    cs2    = wb.createCellStyle();
        HSSFCellStyle    cs3    = wb.createCellStyle();
        HSSFFont         f      = wb.createFont();
        HSSFFont         f2     = wb.createFont();

        f.setFontHeightInPoints(( short ) 12);
        f.setColor(( short ) 0xA);
        f.setBoldweight(HSSFFont.BOLDWEIGHT_BOLD);
        f2.setFontHeightInPoints(( short ) 10);
View Full Code Here
103
104
105
106
107
108
109
110
111
112
113
        row = worksheet.createRow((short)3);

        HSSFCellStyle style = wb.createCellStyle();
        style.setBorderBottom(HSSFCellStyle.BORDER_THIN);
        font = wb.createFont();
        font.setBoldweight(HSSFFont.BOLDWEIGHT_BOLD);

        value = new HSSFRichTextString("Name");
        value.applyFont(font);
        HSSFCell cell = row.createCell((short)0);
View Full Code Here
80
81
82
83
84
85
86
87
88
89
90
    // -------------------------------------------------------- Private Methods

    private HSSFWorkbook createWorkbook() {
        HSSFWorkbook wb = new HSSFWorkbook();

        HSSFFont font = wb.createFont();
        font.setBoldweight(HSSFFont.BOLDWEIGHT_BOLD);

        HSSFSheet worksheet = wb.createSheet("Customers");
        worksheet.setColumnWidth((short) 0, (short)(20 * 256));
        worksheet.setColumnWidth((short) 1, (short)(30 * 256));
 
View Full Code Here
119
120
121
122
123
124
125
126
127
128
129
    @SuppressWarnings("deprecation")
    private HSSFWorkbook createWorkbook() {
        HSSFWorkbook wb = new HSSFWorkbook();

        HSSFFont font = wb.createFont();
        font.setBoldweight(HSSFFont.BOLDWEIGHT_BOLD);

        HSSFSheet worksheet = wb.createSheet("Customers");
        worksheet.setColumnWidth(0, (20 * 256));
        worksheet.setColumnWidth(1, (30 * 256));
 
View Full Code Here
142
143
144
145
146
147
148
149
150
151
152
        row = worksheet.createRow(3);

        HSSFCellStyle style = wb.createCellStyle();
        style.setBorderBottom(HSSFCellStyle.BORDER_THIN);
        font = wb.createFont();
        font.setBoldweight(HSSFFont.BOLDWEIGHT_BOLD);

        value = new HSSFRichTextString("Name");
        value.applyFont(font);
        HSSFCell cell = row.createCell(0);
View Full Code Here
147
148
149
150
151
152
153
154
155
156
157
      cellStyle_timestamp.setDataFormat(HSSFDataFormat.getBuiltinFormat("m/d/yy h:mm"));

      HSSFCellStyle cellStyle_decimal = workbook.createCellStyle();
      cellStyle_decimal.setAlignment(HSSFCellStyle.ALIGN_RIGHT);

      HSSFFont font_title = workbook.createFont();
      font_title.setColor((short) 0xc);
      font_title.setBoldweight(HSSFFont.BOLDWEIGHT_BOLD);
      font_title.setItalic(true);
      font_title.setUnderline(HSSFFont.U_DOUBLE);
      cellStyle_title.setFont(font_title);
View Full Code Here
146
147
148
149
150
151
152
153
154
155
156
      cellStyle_timestamp.setDataFormat(HSSFDataFormat.getBuiltinFormat("m/d/yy h:mm"));

      HSSFCellStyle cellStyle_decimal = workbook.createCellStyle();
      cellStyle_decimal.setAlignment(HSSFCellStyle.ALIGN_RIGHT);

      HSSFFont font_title = workbook.createFont();
      font_title.setColor((short) 0xc);
      font_title.setBoldweight(HSSFFont.BOLDWEIGHT_BOLD);
      font_title.setItalic(true);
      font_title.setUnderline(HSSFFont.U_DOUBLE);
      cellStyle_title.setFont(font_title);
View Full Code Here
65
66
67
68
69
70
71
72
73
74
75
    sheet.setColumnWidth((short) 12, (short) 3000);
    sheet.setColumnWidth((short) 13, (short) 6500);
    sheet.setColumnWidth((short) 14, (short) 6500);

    // --------- En-tête -----------
    HSSFFont font = wb.createFont();
    font.setFontHeightInPoints((short) 18);
    font.setFontName("Arial");

    HSSFCellStyle style = wb.createCellStyle();
    style.setFont(font);
View Full Code Here
TOP
Copyright © 2018 www.massapi.com. 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.