Examples of createCellStyle()

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

140
141
142
143
144
145
146
147
148
149
150
        worksheet.createRow(2);

        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");
View Full Code Here

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

97
98
99
100
101
102
103
104
105
106
107
     
      OutputStream out = new FileOutputStream(sourcePath);
     
      HSSFWorkbook workbook = new HSSFWorkbook();
     
      HSSFCellStyle style = workbook.createCellStyle();
      // 设置这些样式
      style.setFillForegroundColor(HSSFColor.GREY_25_PERCENT.index);
      style.setFillPattern(HSSFCellStyle.SOLID_FOREGROUND);
      style.setBorderBottom(HSSFCellStyle.BORDER_THIN);
      style.setBorderLeft(HSSFCellStyle.BORDER_THIN);
View Full Code Here

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

113
114
115
116
117
118
119
120
121
122
123
      font.setFontHeightInPoints((short) 12);
      font.setBoldweight(HSSFFont.BOLDWEIGHT_BOLD);
      // 把字体应用到当前的样式
      style.setFont(font);
     
      HSSFCellStyle styledata = workbook.createCellStyle();
      // 设置这些样式
      styledata.setBorderBottom(HSSFCellStyle.BORDER_THIN);
      styledata.setBorderLeft(HSSFCellStyle.BORDER_THIN);
      styledata.setBorderRight(HSSFCellStyle.BORDER_THIN);
      styledata.setBorderTop(HSSFCellStyle.BORDER_THIN);
View Full Code Here

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

110
111
112
113
114
115
116
117
118
119
120
      OutputStream out = new FileOutputStream(new File(sourcePath));

      HSSFWorkbook workbook = new HSSFWorkbook();

      HSSFCellStyle style = workbook.createCellStyle();
      // 设置这些样式
      style.setFillForegroundColor(HSSFColor.GREY_25_PERCENT.index);
      style.setFillPattern(HSSFCellStyle.SOLID_FOREGROUND);
      style.setBorderBottom(HSSFCellStyle.BORDER_THIN);
      style.setBorderLeft(HSSFCellStyle.BORDER_THIN);
View Full Code Here

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

126
127
128
129
130
131
132
133
134
135
136
      font.setFontHeightInPoints((short) 12);
      font.setBoldweight(HSSFFont.BOLDWEIGHT_BOLD);
      // 把字体应用到当前的样式
      style.setFont(font);

      HSSFCellStyle styledata = workbook.createCellStyle();
      // 设置这些样式
      styledata.setBorderBottom(HSSFCellStyle.BORDER_THIN);
      styledata.setBorderLeft(HSSFCellStyle.BORDER_THIN);
      styledata.setBorderRight(HSSFCellStyle.BORDER_THIN);
      styledata.setBorderTop(HSSFCellStyle.BORDER_THIN);
View Full Code Here

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

99
100
101
102
103
104
105
106
107
108
109
     
      OutputStream out = new FileOutputStream(sourcePath);
     
      HSSFWorkbook workbook = new HSSFWorkbook();
     
      HSSFCellStyle style = workbook.createCellStyle();
      // 设置这些样式
      style.setFillForegroundColor(HSSFColor.GREY_25_PERCENT.index);
      style.setFillPattern(HSSFCellStyle.SOLID_FOREGROUND);
      style.setBorderBottom(HSSFCellStyle.BORDER_THIN);
      style.setBorderLeft(HSSFCellStyle.BORDER_THIN);
View Full Code Here

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

115
116
117
118
119
120
121
122
123
124
125
      font.setFontHeightInPoints((short) 12);
      font.setBoldweight(HSSFFont.BOLDWEIGHT_BOLD);
      // 把字体应用到当前的样式
      style.setFont(font);
     
      HSSFCellStyle styledata = workbook.createCellStyle();
      // 设置这些样式
      styledata.setBorderBottom(HSSFCellStyle.BORDER_THIN);
      styledata.setBorderLeft(HSSFCellStyle.BORDER_THIN);
      styledata.setBorderRight(HSSFCellStyle.BORDER_THIN);
      styledata.setBorderTop(HSSFCellStyle.BORDER_THIN);
View Full Code Here

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

88
89
90
91
92
93
94
95
96
97
98
      }
    }
    final List<String> attributeIds = new ArrayList<String>(attributeIdSet);

    HSSFWorkbook wb = new HSSFWorkbook();
    final HSSFCellStyle localeCellStyle = wb.createCellStyle();
    localeCellStyle.setLocked(false);
    final HSSFSheet sheet = wb.createSheet("translation");
    createHeaderRow(sheet.createRow(0), locales, attributeIds);

    Exporter.export(ls, locales, new Callback<LocaleItem>() {
View Full Code Here

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

438
439
440
441
442
443
444
445
446
447
448
        assertEquals(IndexedColors.AUTOMATIC.getIndex(), style1.getFillBackgroundColor());
        assertNull(style1.getFillBackgroundXSSFColor());

        //compatibility with HSSF
        HSSFWorkbook wb2 = new HSSFWorkbook();
        HSSFCellStyle style2 = wb2.createCellStyle();
        assertEquals(style2.getFillBackgroundColor(), style1.getFillBackgroundColor());
        assertEquals(style2.getFillForegroundColor(), style1.getFillForegroundColor());
        assertEquals(style2.getFillPattern(), style1.getFillPattern());

        assertEquals(style2.getLeftBorderColor(), style1.getLeftBorderColor());
View Full Code Here

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

561
562
563
564
565
566
567
568
569
570
571
        assertNotNull(XSSFTestDataSamples.writeOutAndReadBack(wb1));

        //compatibility with HSSF
        HSSFWorkbook wb2 = new HSSFWorkbook();
        HSSFCellStyle style2 = wb2.createCellStyle();
        assertEquals(style2.getFillBackgroundColor(), style1.getFillBackgroundColor());
        assertEquals(style2.getFillForegroundColor(), style1.getFillForegroundColor());
        assertEquals(style2.getFillPattern(), style1.getFillPattern());

        assertEquals(style2.getLeftBorderColor(), style1.getLeftBorderColor());
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.