easy-poi 修改单元格样式

// 导出路径
String outPath = "E:\\文件.xls";

// 导出excel表
Workbook workbook = ExcelExportUtil.exportExcel(
        new ExportParams("标题", "sheet名"),
        Build.class, buildBlgMacInfo
);
// 设置表格样式
// 设置字体样式，颜色置为红色
Font font = workbook.createFont();
short index = HSSFColor.HSSFColorPredefined.RED.getIndex();
font.setColor(index);
CellStyle redFontStyle = workbook.createCellStyle();
boolean clone = false;
// 设置字体样式，字体加粗
Font font2 = workbook.createFont();
CellStyle boldFontStyle = workbook.createCellStyle();
font2.setBold(true);

//        font.setBold(true);
//        font.setColor(HSSFColor.RED.index);
//        fontColor.setFont(font);
//        font.setFontName("宋体");

            Iterator<Sheet> sheetIterator = workbook.sheetIterator();
            while (sheetIterator.hasNext()) {
                Iterator<Row> rowIterator = sheetIterator.next().rowIterator();
                while (rowIterator.hasNext()) {
                    Iterator<Cell> cellIterator = rowIterator.next().cellIterator();
                    while (cellIterator.hasNext()) {
                        Cell cell = cellIterator.next();
                        String cellValue = cell.getStringCellValue().trim();
                        if (cellValue.endsWith("%")) {
                            float value = Float.parseFloat(cellValue.substring(0, cellValue.length() - 1));
                            if (!clone) {
                                // 设置一个红色的字体样式
                                redFontStyle.cloneStyleFrom(cell.getCellStyle());
                                redFontStyle.setFont(font);
                                // 设置一个粗体字体样式
                                boldFontStyle.cloneStyleFrom(cell.getCellStyle());
                                boldFontStyle.setFont(font2);

                                clone = true;
                            }
                            if (value >= percent) {
                                cell.setCellStyle(redFontStyle);  // 修改这个单元格的字体
                            } else if (value > 0) {
                                cell.setCellStyle(boldFontStyle);  // 设置这个单元格中的字体为粗体
                            }

//                        CellStyle style = workbook.createCellStyle();
//                        style.setAlignment(HorizontalAlignment.CENTER);
//                        style.setFont(font);
//                        cell.setCellStyle(style);
                        }
                    }
                }
            }

// 把内存中的excel写到磁盘中去
if (workbook != null) {
    FileOutputStream outputStream = null;
    try {
        outputStream = new FileOutputStream(outPath);
        workbook.write(outputStream);
    } catch (IOException e) {
        e.printStackTrace();
    } finally {
        try {
            if (outputStream != null) {
                outputStream.close();
            }
            workbook.close();
        } catch (Exception e) {
            e.printStackTrace();
        }
    }
} else {
    System.err.println("导出失败");
}