1、导入依赖
<dependency>
<groupId>cn.afterturn</groupId>
<artifactId>easypoi-spring-boot-starter</artifactId>
<version>4.1.3</version>
</dependency>
2、导出
ExportParams exportParams = new ExportParams();// 可以更改导出样式
Workbook workBook = ExcelExportUtil.exportExcel(exportParams, 数据类.class, 数据list); // 也可以导出map类型
try {
workBook.write(response.getOutputStream());
} catch (IOException e) {
throw new RuntimeException(e);
}
3、使用到的注解
@Excel(name = "", needMerge = true)
@Excel(name = "", needMerge = true, format = "yyyy-MM-dd")
@Excel(name = "", needMerge = true, replace = {"不合格_false","合格_true"})
@ExcelCollection(name = "")
4、案例一:存在主表子表情况(数据库中建立两个表)
(1)主表
@Getter
@Setter
@TableName("master")
public class Master {
@JSONField(format = "yyyy-MM-dd")
@DateTimeFormat(pattern = "yyyy-MM-dd")
@Excel(name = "日期", needMerge = true, format = "yyyy-MM-dd")
// 导出到excel时,日期格式为format定义的格式
private Date produceDate;
@Excel(name = "右侧是否合格", needMerge = true, replace = {"不合格_false","合格_true"})
// 当rightQualified的值为false时候,导出excel中的内容转为不合格;反之为合格
private Boolean rightQualified;
@Excel(name = "左侧是否合格", needMerge = true, replace = {"不合格_false","合格_true"})
private Boolean leftQualified;
@Excel(name = "心情", needMerge = true)
private String mood;
@ExcelCollection(name = "记录详情")
@TableField(exist = false)
private List<Detail> recordDetails;
}
(2)子表
@Getter
@Setter
@TableName("detail")
public class Detail {
// 主表Id
private String recordId;
@Excel(name = "组别编号")
private Integer groupNo;
@Excel(name = "测量点位", replace = {"左_LEFT","右_RIGHT"})
// 当testPointLocation枚举类型为LEFT时,导出内容为左;反之为右
private TestPointLocationEnum testPointLocation;
}
案例一这种情况,加上对应注解,使用“导出”中的代码直接导出就行。
5、案例二:存在主表子表情况(数据库中建立一个表)
(1)表
@Getter
@Setter
@TableName(value = "master", autoResultMap = true)
public class Master {
@JSONField(format = "yyyy-MM-dd")
@Excel(name = "日期", needMerge = true,format = "yyyy-MM-dd")
private Date date;
@Excel(name = "班次", needMerge = true, replace = {"白班_day", "夜班_night"})
private String classes;
@ExcelCollection(name = "项目明细")
@TableField(typeHandler = FastjsonTypeHandler.class)
private List<Detail> projectDetail;
// 子表
@Data
public static class Detail implements Serializable {
private static final long serialVersionUID = 1L;
@Excel(name = "项目")
private String project;
@Excel(name = "投资额")
private Integer amountInvested;
@Excel(name = "投资人")
private Integer investor;
}
}
在案例二中,从数据库中查出数据后,使用“导出”中的代码,子类数据将映射不到excel中,是因为使用了 :
@TableField(typeHandler = FastjsonTypeHandler.class)
FastjsonTypeHandler将会使得查出来的子类数据存储形式为map类型(我在debug时候发现afterTurn.easypoi框架里面在获取子类时,得到内容为空,我认为是“导出”中的“数据list”必须是纯的list)。所以要使用如下代码对子类数据进行处理:
JSONObject jsonObject1 = JSONObject.parseObject(String.valueOf(projectDetail.get(i)))
String project = (String) jsonObject1.get("project");
String amountInvested= (String) jsonObject1.get("amountInvested");
String investor= (String) jsonObject1.get("investor");
Master.Detail detail = new Master.Detail();
detail.setProject(project);
detail.setAmountInvested(amountInvested);
detail.setInvestor(investor);
6、声明
本人是在做项目过程中遇到以上问题,并使用以上方法解决,如有不对,请指教。