Java Excel导出(包含图片) —— Easypoi

勇敢的小刘

于 2022-05-19 13:32:15 发布

阅读量2k

点赞数

分类专栏： Java 文章标签： java 开发语言

本文链接：https://blog.csdn.net/weixin_45662627/article/details/124861349

版权

Java Excel导出(包含图片) —— Easypoi

Easypoi官网文档：http://doc.wupaas.com/docs/easypoi/easypoi-1c0u6ksp2r091

一、添加依赖

        <dependency>
            <groupId>cn.afterturn</groupId>
            <artifactId>easypoi-base</artifactId>
            <version>4.4.0</version>
        </dependency>
        <dependency>
            <groupId>cn.afterturn</groupId>
            <artifactId>easypoi-web</artifactId>
            <version>4.4.0</version>
        </dependency>
        <dependency>
            <groupId>cn.afterturn</groupId>
            <artifactId>easypoi-annotation</artifactId>
            <version>4.4.0</version>
        </dependency>

二、给实体类中需要导出的字段添加注解 @Excel

@Data
public class ExportEntity {
   
    private Long id;
	@Excel(name = "名称",orderNum = "1",width = 20)
	private String name;
	@Excel(name = "年龄",orderNum = "2",width=20)
	private String age;
	@Excel(name = "性别",orderNum = "3",width=20)
	private String sex;
    //type 1文本 2图片 3函数 10数字  默认1
	@Excel(name = "头像",orderNum = "4",type = 2,width=15,height = 10)
	private