java poi导入图片问题

最新推荐文章于 2024-07-20 18:01:34 发布

cangyuf

最新推荐文章于 2024-07-20 18:01:34 发布

阅读量2.4k

点赞数

分类专栏： java 文章标签：工作

本文链接：https://blog.csdn.net/cangyuf/article/details/78584244

版权

java 专栏收录该内容

3 篇文章 0 订阅

订阅专栏

/**
     * 工作薄对象
     */
    private SXSSFWorkbook wb;

    /**
     * 工作表对象
     */
    private Sheet sheet;

    /**
     * 样式列表
     */
    private Map<String, CellStyle> styles;

    /**
     * 当前行号
     */
    private int rownum;

    private CreationHelper helper;  
    private Drawing drawing;  
    private ClientAnchor anchor; 

    private void drawPictureInfoExcel() {
        this.wb = new SXSSFWorkbook(500);
        this.sheet = wb.createSheet("Export");
        this.styles = createStyles(wb);

        this.drawing = sheet.createDrawingPatriarch();
        this.helper = wb.getCreationHelper(); 
        this.anchor = helper.createClientAnchor();

        InputStream is = new FileInputStream(pictureId);            
            byte[] bytes = IOUtils.toByteArray(is);
            int pictureIdx= wb.addPicture(bytes, SXSSFWorkbook.PICTURE_TYPE_PNG);

        // 图片插入坐标  
            anchor.setDx1(0);
            anchor.setDy1(0);
            anchor.setDx2(0);
            anchor.setDy2(0);
            anchor.setCol1(cellIndex);  
            anchor.setRow1(row.getRowNum());
            anchor.setCol2(cellIndex+1);  
            anchor.setRow2(row.getRowNum()+1);

            // 插入图片  
            Picture pict = drawing.createPicture(anchor, pictureIdx);  
           //pict.resize();//以原来图片大小的形式存放
    }