SpringBoot2.X + EasyExcel(76)

官网:EasyExcel

其他简单Excel框架:ExcelUtil

1、pom依赖

com.alibaba easyexcel 2.2.6

2、实体类

@Data @NoArgsConstructor @AllArgsConstructor public class User { @ExcelProperty(value = "姓名") private String userName; @NumberFormat("#.##%") @ExcelProperty(value = "体脂率") private double fat; @ExcelProperty(value = "编写日期") private String birthday; }

3、导出数据

@GetMapping(value = "/write") public String write(){ String url = "/Users/mac/Desktop/76521.xlsx"; List list = Arrays.asList( new User("刘飞",0.2512,"2002-01-12"), new User("张羽",0.2345,"2002-06-22"), new User("关备",0.1812,"2002-04-03") ); EasyExcel.write(url,User.class).sheet("Sheet").doWrite(list); return "OK"; }

测试如下:

4、导入

public class DataListener extends AnalysisEventListener {

List<User> list \= new ArrayList<>(); 

_/** _ * 这个每一条数据解析都会来调用 * @param user _excel对应一个对象 _ * @param analysisContext _上下文 _ */ @Override public void invoke(User user, AnalysisContext analysisContext) { list.add(user); }

_/\*\*

_ * 所有数据解析完成了 最终会调用 * @param analysisContext _上下文 _ */ @Override public void doAfterAllAnalysed(AnalysisContext analysisContext) { System.out.println("所有数据加载完毕,在里面将数据存储到数据库"); System.out.println(JSON.toJSON(list)); } }

接口:

@GetMapping(value = "/read") public String read(){ String url = "/Users/mac/Desktop/76521.xlsx"; EasyExcel.read(url,User.class, new DataListener()).sheet().doRead(); return "OK"; }

测试结果:

测试OK。

评论

暂无评论