写个工具将所有颜色代码的实际效果生成出来
1 static void colorTest() throws IOException {
2 Workbook wb = new HSSFWorkbook();
3 Sheet sheet = wb.createSheet("colorful");
4 int rowNum = 0;
5 for (IndexedColors color : IndexedColors.values()) {
6 Row row = sheet.createRow(rowNum++);
7 Cell cell = row.createCell(0);
8 cell.setCellValue(color.toString());
9 Cell cellColor = row.createCell(1);
10 CellStyle style = wb.createCellStyle();
11 style.setFillPattern(FillPatternType.SOLID_FOREGROUND);
12 style.setFillForegroundColor(color.getIndex());
13 cellColor.setCellStyle(style);
14 }
15 sheet.setColumnWidth(0,25*256);
16 sheet.setColumnWidth(1,50*256);
17 FileOutputStream fout = new FileOutputStream(new File("d:\\colors.xls"));
18 wb.write(fout);
19 wb.close();
20 fout.close();
21 }
生成结果:
实际使用:
cellStyle.setFillForegroundColor(IndexedColors.LIGHT_CORNFLOWER_BLUE.getIndex()); //单元格背景色
cellStyle.setFillPattern(FillPatternType.SOLID_FOREGROUND);//前景填充模式
其他常用Excel样式设置:
cellStyle.setAlignment(HorizontalAlignment.CENTER);//水平居中
cellStyle.setVerticalAlignment(VerticalAlignment.CENTER);//垂直居中
cellStyle.setBorderBottom(BorderStyle.THIN); //下边框
cellStyle.setBorderLeft(BorderStyle.THIN);//左边框
cellStyle.setBorderTop(BorderStyle.THIN);//上边框
cellStyle.setBorderRight(BorderStyle.THIN);//右边框
HSSFFont font = workbook.createFont();
font.setFontHeightInPoints((short)9);//字体大小
font.setFontName("微软雅黑");//字体
font.setBold(true); //加粗
font.setColor(Font.COLOR_NORMAL); //字体颜色
cellStyle.setFont(font);
cellStyle.setDataFormat(HSSFDataFormat.getBuiltinFormat("0.00%")); //设置数字以百分比显示
附easypoi学习文档:
http://doc.wupaas.com/docs/easypoi/easypoi-1c10ldlb9epsk