EasyExcel关于导出图片,没有废话,直接教程使用
导入依赖
<dependency>
<groupId>com.alibaba</groupId>
<artifactId>easyexcel</artifactId>
<version>2.1.1</version>
</dependency>
<dependency>
<groupId>org.apache.poi</groupId>
<artifactId>poi-ooxml</artifactId>
<version>3.17</version>
</dependency>
<dependency>
<groupId>org.apache.poi</groupId>
<artifactId>poi-ooxml-schemas</artifactId>
<version>3.17</version>
</dependency>
<dependency>
<groupId>org.apache.poi</groupId>
<artifactId>poi</artifactId>
<version>3.17</version>
</dependency>
实体类
@Data
@ContentRowHeight(200)
@HeadRowHeight(50)
@ColumnWidth(200 / 8)
public class DemoVo {
@ColumnWidth(40)
@ExcelProperty(value = "图片", index =0)
private URL url;
}
@ContentRowHeight(200) 行高
@HeadRowHeight(50) 表头高度
@ExcelProperty(value = “图片”, index =0) value 指表头名称
Controller
按钮
效果展示
希望有三连~