XSSFWorkbook wb = new XSSFWorkbook();

CellStyle style = wb.createCellStyle();

style.setBorderRight(CellStyle.BORDER_THIN); // 设置边框线  上下左右 style.setRightBorderColor(IndexedColors.GREY_80_PERCENT.getIndex()); style.setBorderLeft(CellStyle.BORDER_THIN); style.setLeftBorderColor(IndexedColors.GREY_50_PERCENT.getIndex()); style.setBorderTop(CellStyle.BORDER_THIN); style.setTopBorderColor(IndexedColors.GREY_50_PERCENT.getIndex()); style.setBorderBottom(CellStyle.BORDER_THIN); style.setBottomBorderColor(IndexedColors.GREY_50_PERCENT.getIndex());

//自动换行 style.setWrapText(true);

style.setAlignment(CellStyle.ALIGN_CENTER);// 设置居中 style.setVerticalAlignment(CellStyle.VERTICAL_CENTER);// 设置居中 style.setFillPattern(HSSFCellStyle.SOLID_FOREGROUND); Font font = wb.createFont(); font.setColor(IndexedColors.RED.index);//自体颜色 style.setFont(font); return style;