[alibaba/easyexcel]registerWriteHandler 不处理空单元格的样式

2023-12-09 923 views
9

异常代码

private static HorizontalCellStyleStrategy getHorizontalCellStyleStrategy() {
        // 头部
        WriteCellStyle headStyle = new WriteCellStyle();
        headStyle.setFillForegroundColor(IndexedColors.GREY_25_PERCENT.getIndex());
        WriteFont headFont = new WriteFont();
        headFont.setFontHeightInPoints((short) 14);
        headFont.setBold(true);
        headStyle.setWriteFont(headFont);

        // 内容
        WriteCellStyle contentStyle = new WriteCellStyle();
        contentStyle.setRightBorderColor(IndexedColors.BLACK.getIndex());
        WriteFont contentFont = new WriteFont();
        contentFont.setFontHeightInPoints((short) 11);
        contentStyle.setWriteFont(contentFont);
        contentStyle.setBorderTop(BorderStyle.THIN);
        contentStyle.setTopBorderColor(IndexedColors.BLACK.getIndex());
        contentStyle.setBorderRight(BorderStyle.THIN);
        contentStyle.setRightBorderColor(IndexedColors.BLACK.getIndex());
        contentStyle.setBorderBottom(BorderStyle.THIN);
        contentStyle.setBottomBorderColor(IndexedColors.BLACK.getIndex());
        contentStyle.setBorderLeft(BorderStyle.THIN);
        contentStyle.setLeftBorderColor(IndexedColors.BLACK.getIndex());
        contentStyle.setHidden();
        return new HorizontalCellStyleStrategy(headStyle, contentStyle);
    }

异常提示

/

问题描述

当一个单元格内容为空时,表格不会显示设置的样式。有无api可以让所有内容都渲染设置的样式。

回答

0

7438e9d72ede37102262cb69ac6ff7f6

6

试了@ContentStyle的方式,同样。。。