天天看點

easypoi 導出 備注異常的字型顔色為紅色

public static void exportExcel(String fileName, HttpServletResponse response, Class<?> pojoClass, List<?> list, String sheet, String title, List<Integer> rowNumList) {
        ExportParams params = new ExportParams();
        params.setStyle(ExcelStyleUtil.class);
        params.setSheetName(sheet);
        params.setTitle(title);
        Workbook workbook = ExcelExportUtil.exportExcel(params, pojoClass, list);
        Font font = workbook.createFont();
        font.setColor(HSSFColor.HSSFColorPredefined.RED.getIndex());
        font.setFontHeightInPoints((short) 11);
        Sheet sheetAt = workbook.getSheetAt(0);
        HSSFCellStyle style = (HSSFCellStyle) workbook.createCellStyle();
        style.setAlignment(HorizontalAlignment.CENTER);
        style.setVerticalAlignment(VerticalAlignment.CENTER);
        style.setFont(font);
        if (JudgeUtils.isNotEmpty(rowNumList)) {
            int j = 0;
            for (int i = 0; i < rowNumList.size(); i++) {
                sheetAt.getRow(rowNumList.get(i) + j).getCell(9).setCellStyle(style);
                j++;
            }
        }
        downLoadExcel(fileName, response, workbook);
    }
           

結合以上核心代碼可以實作如下最後一列備注為紅色 隻供參考

easypoi 導出 備注異常的字型顔色為紅色