MYBLOG

1.单元格操作

CellStyle titleStyle = workbook.createCellStyle();
Font font = workbook.createFont();
//字体
font.setFontName("微软雅黑");
titleStyle.setFont(font);
//左右对齐
titleStyle.setAlignment(HorizontalAlignment.CENTER);
//上下对齐
titleStyle.setVerticalAlignment(VerticalAlignment.CENTER);
//自动换行
titleStyle.setWrapText(true);
//设置背景色
XSSFCellStyle styleTemp = ((XSSFCellStyle) titleStyle);
//自定义RGB颜色
XSSFColor xssfColor = new XSSFColor(new java.awt.Color(248, 203, 173));
styleTemp.setFillForegroundColor(xssfColor);
//一定要设置填充模式，不然不生效
titleStyle.setFillPattern(FillPatternType.SOLID_FOREGROUND);
return titleStyle;