easypoi 导出备注异常的字体颜色为红色

最新推荐文章于 2025-01-26 18:58:20 发布

aq_money

最新推荐文章于 2025-01-26 18:58:20 发布

阅读量1.6k

点赞数 1

文章标签： java c++ 开发语言

本文链接：https://blog.youkuaiyun.com/aq_money/article/details/127517870

版权

  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);
    }