本文讲述的是从数据库查出数据并且导出excel。
1、所用依赖(easyexcel):
<dependency>
<groupId>com.alibaba</groupId>
<artifactId>easyexcel</artifactId>
<version>3.2.1</version>
</dependency>
2、根据文件所需要字段定义一个实体类:
package com.biao.vo.excelVo;
import com.alibaba.excel.annotation.ExcelProperty;
import io.swagger.annotations.ApiModel;
import io.swagger.annotations.ApiModelProperty;
import lombok.Data;
/**
* @author xxx
*/
@Data
@ApiModel(value = "xxx导出对象", description = "xxx导出对象")
public class ExportInfoVo {
@ApiModelProperty(value = "id")
private String id;
@ApiModelProperty(value = "项目名称")
@ExcelProperty(value = "项目名称")
private String projectName;
@ApiModelProperty(value = "项目属性名称")
@ExcelProperty(value = &