SpringBoot集成阿里easyexcel（三）CellWriteHandler图片转换

最新推荐文章于 2024-06-12 15:43:10 发布

Lady伯德

最新推荐文章于 2024-06-12 15:43:10 发布

阅读量2.8k

点赞数 3

分类专栏： EasyExcel

本文链接：https://blog.csdn.net/her_he/article/details/125394077

版权

Excel处理单元格处理器数据转换图片插入自定义逻辑

关键词由CSDN通过智能技术生成

EasyExcel 专栏收录该内容

5 篇文章 4 订阅

订阅专栏

继承单元格处理器，通过重写不同方法，对单元格进行处理。

public class MplImageExportHandler implements CellWriteHandler {

	/**
	*在创建单元格之前调用 
	*/
    @Override
    public void beforeCellCreate(WriteSheetHolder writeSheetHolder, WriteTableHolder writeTableHolder, Row row, Head head, Integer integer, Integer integer1, Boolean aBoolean) {

    }

    /**
	*在创建单元格之后调用 
	*/
    @Override
    public void afterCellCreate(WriteSheetHolder writeSheetHolder, WriteTableHolder writeTableHolder, Cell cell, Head head, Integer integer, Boolean aBoolean) {

    }

    /**
	*在转换数据之后调用
	*/
    @Override
    public void afterCellDataConverted(WriteSheetHolder writeSheetHolder, WriteTableHolder writeTableHolder, CellData cellData, Cell cell, Head head, Integer integer, Boolean aBoolean) {
        if(cell.getRowIndex()>0 && cell.getColumnIndex()==10) {
            cellData.setType(CellDataTypeEnum.EMPTY);
        }
    }
    /**
	*在单元格上的所有操作完成后调用(cell当前单元格)
	*/
    @Override
    public void afterCellDispose(WriteSheetHolder writeSheetHolder, WriteTableHolder writeTableHolder, List<CellData> list, Cell cell, Head head, Integer integer, Boolean aBoolean) {
        if(cell.getRowIndex()>0 && cell.getColumnIndex()==10) {
            Sheet sheet = cell.getSheet();

            int index = sheet.getWorkbook().addPicture(list.get(0).getImageValue(), HSSFWorkbook.PICTURE_TYPE_PNG);

            Drawing drawing = sheet.getDrawingPatriarch();
            if (drawing == null) {
                drawing = sheet.createDrawingPatriarch();
            }
            CreationHelper helper = sheet.getWorkbook().getCreationHelper();
            ClientAnchor anchor = helper.createClientAnchor();
            // 设置图片坐标
            anchor.setDx1(0);
            anchor.setDy1(0);
            anchor.setDx2(0);
            anchor.setDy2(0);

            //设置图片位置
            anchor.setCol1(cell.getColumnIndex());
            anchor.setRow1(cell.getRowIndex());
            anchor.setCol2(cell.getColumnIndex()+1);
            anchor.setRow2(cell.getRowIndex()+1);

            // 设置图片可以随着单元格移动
            anchor.setAnchorType(ClientAnchor.AnchorType.MOVE_AND_RESIZE);
            Picture picture = drawing.createPicture(anchor, index);
        }
    }
}