Hutool工具类之excel导入导出

文章目录

1、导入excel

ExcelReader reader = ExcelUtil.getReader("D:\\test.xlsx");// 第一种，MapList<Map<String, Object>> maps = reader.readAll();System.out.println("maps = " + maps);// 第二种，实体类List<User> userList = reader.readAll(User.class);System.out.println("userList = " + userList);

2、导出excel

ExcelWriter writer = ExcelUtil.getWriter(false);// 设置别名reader.addHeaderAlias("名字", "name");reader.addHeaderAlias("年龄", "age");// 第一种，MapList<Map<String, Object>> mapList = new ArrayList<>();Map map = new HashMap();map.put("name", "Tom");map.put("age", 25);mapList.add(map);writer.write(mapList, true);// 第二种，实体类List<User> userList = new ArrayList<>();userList.add(new User("Tom", 25));writer.write(userList, true);writer.flush(new FileOutputStream("D:/users.xls"));

如果觉得《Hutool工具类之excel导入导出》对你有帮助，请点赞、收藏，并留下你的观点哦！