easyexcel单元格画斜线

Question

使用easyexcel填充模板时，怎么给指定单元格画斜线，看教程重写了afterCellCreate，但是好像不起作用

public class CustomCellWriteHandler implements CellWriteHandler {

    @Override
    public void afterCellCreate(CellWriteHandlerContext context) {
        Cell cell = context.getCell();

        if (cell != null) {
            // 这里可以对cell进行任何操作
            Sheet sheet = context.getWriteSheetHolder().getSheet();
            XSSFDrawing drawingPatriarch = (XSSFDrawing) sheet.createDrawingPatriarch();

            ClientAnchor anchor = drawingPatriarch.createAnchor(0, 0, 1023, 255, (short) 0, 0, (short) 0, 0);
            anchor.setRow1(0);
            anchor.setCol1(0);
            anchor.setRow2(1);
            anchor.setCol2(1);
            XSSFSimpleShape simpleShape = drawingPatriarch.createSimpleShape((XSSFClientAnchor) anchor);
            simpleShape.setShapeType(ShapeTypes.LINE);

            // 设置线宽
            simpleShape.setLineWidth(0.5);
            // 设置线的风格
            simpleShape.setLineStyle(0);
            // 设置线的颜色
            simpleShape.setLineStyleColor(0, 0, 0);
        }

    }

}




  WriteSheet writeSheet = EasyExcel.writerSheet(aaa.getBillNo())
                    .registerWriteHandler(new CustomCellWriteHandler())
                    .build();

Answer 1

【以下回答由 GPT 生成】

import org.apache.poi.common.usermodel.LineCap;
import org.apache.poi.ss.usermodel.IndexedColors;
import org.apache.poi.xddf.usermodel.XDDFSolidFillProperties;
import org.apache.poi.xddf.usermodel.XDDFLineProperties;
import org.apache.poi.xddf.usermodel.XDDFPresetLineDash;
import org.apache.poi.xssf.usermodel.XSSFClientAnchor;
import org.apache.poi.xssf.usermodel.XSSFDrawing;
import org.apache.poi.xssf.usermodel.XSSFSimpleShape;
import org.apache.poi.xssf.usermodel.XSSFCellStyle;
import org.apache.poi.xssf.usermodel.XSSFColor;
import org.apache.poi.xssf.usermodel.XSSFSheet;
import org.apache.poi.xssf.usermodel.extensions.XSSFCellBorder.BorderSide;
import org.apache.poi.xssf.usermodel.XSSFColor;

import com.alibaba.excel.event.WriteHandler;
import com.alibaba.excel.write.metadata.holder.WriteSheetHolder;
import com.alibaba.excel.write.metadata.holder.WriteTableHolder;
import com.alibaba.excel.write.metadata.holder.WriteWorkbookHolder;
import com.alibaba.excel.write.metadata.WriteSheet;

import org.apache.poi.ss.usermodel.Cell;
import org.apache.poi.ss.usermodel.ClientAnchor;
import org.apache.poi.ss.usermodel.Row;
import org.apache.poi.ss.util.CellAddress;
import org.apache.poi.ss.util.CellRangeAddress;
import org.apache.poi.ss.util.CellRangeAddressList;
import org.apache.poi.ss.util.CellUtil;

import java.util.Map;

public class CustomCellWriteHandler implements WriteHandler {

    @Override
    public void sheet(int sheetNo, Sheet sheet) {
    }

    @Override
    public void table(int sheetNo, int tableIndex, WriteTableHolder tableHolder) {
    }

    @Override
    public void cell(int sheetNo, int rowIndex, int cellIndex, WriteCellData<?> cellData,
                     Cell cell, WriteSheetHolder writeSheetHolder,
                     WriteTableHolder writeTableHolder, WriteWorkbookHolder writeWorkbookHolder) {
        // Specify the cell address where you want to draw the diagonal line
        if (rowIndex == 0 && cellIndex == 0) {
            // Get the sheet and drawing object
            XSSFSheet sheet = (XSSFSheet) writeSheetHolder.getSheet();
            XSSFDrawing drawing = sheet.getDrawingPatriarch();

            // Create an anchor point for the diagonal line
            XSSFClientAnchor anchor = new XSSFClientAnchor(0, 0, 0, 0, 0, 0, 1, 1);

            // Create a simple shape and set its properties
            XSSFSimpleShape shape = drawing.createSimpleShape(anchor);
            shape.setShapeType(ShapeTypes.LINE);
            shape.setLineWidth(1); // Set the line width to 1 point
            shape.setLineStyle(0); // Set the line style to solid
            shape.setLineStyleColor(0, 0, 0); // Set the line color (RGB values)

            // Set the start and end points of the diagonal line
            shape.getCTShape().getSpPr().getXfrm().setX((long) cell.getCTCell().getXfrm().getX());
            shape.getCTShape().getSpPr().getXfrm().setY((long) cell.getCTCell().getXfrm().getY());
            shape.getCTShape().getSpPr().getXfrm().setX2((long) (cell.getCTCell().getXfrm().getX() + cell.getCTCell().getXfrm().getExt().getCx()));
            shape.getCTShape().getSpPr().getXfrm().setY2((long) (cell.getCTCell().getXfrm().getY() + cell.getCTCell().getXfrm().getExt().getCy()));
        }
    }
}

使用上述代码来替换您提供的CustomCellWriteHandler类中的代码，并将其设置为EasyExcel的写处理器，以在单元格中绘制斜线。请确保 Sheet 对象是 XSSFSheet 类型，Drawing 对象是 XSSFDrawing 类型。

这段代码将在指定单元格的左上角和右下角之间绘制一条斜线。您可以根据需要自行调整线宽、线型和线色等属性。

这样应该可以让斜线正常显示。如果仍然无法正常显示，请确认您使用的是最新版本的 poi-ooxml 和 poi-ooxml-schemas 等依赖。如果问题仍然存在，请尝试通过更详细的调试来查找问题所在。

【相关推荐】

• 这有个类似的问题, 你可以参考下: https://ask.csdn.net/questions/715949
• 你也可以参考下这篇文章：easyexcel复杂导出，合并单元格，无对象生成easyexcel动态表头
• 除此之外, 这篇博客: EasyExcel实现自定义单元格样式导出中的 EasyExcel实现自定义单元格样式导出 部分也许能够解决你的问题。

如果你已经解决了该问题, 非常希望你能够分享一下解决方案, 写成博客, 将相关链接放在评论区, 以帮助更多的人 ^-^