<dependency>
<groupId>com.alibaba</groupId>
<artifactId>easyexcel</artifactId>
<version>2.2.6</version>
</dependency>
//实体类
@ColumnWidth(25)
public class HkProTransRecordEntity implements Serializable {
@ExcelProperty(value = "审批时间")
private String approvalTime;
@ExcelProperty("审批人")
private String approver;
@ExcelProperty("审批节点")
private String taskDefinitionKey;
@ExcelProperty("审批意见")
private String message;
}
//生成并导出excel代码块
try {
OutputStream out = new FileOutputStream("tempFile\\" + processParam.getSalesman() + processParam.getCreationTime() + ".xlsx");
EasyExcel.write(out, HkProTransRecordEntity.class).sheet("流转记录").doWrite(recordEntityList);
} catch (FileNotFoundException e) {
e.printStackTrace();
}
alibaba-easyexcel
最新推荐文章于 2023-12-27 08:55:00 发布