springboot整合easypoi实现简单的excel导出导入

1、pom.xml配置

<dependency> <groupId>org.jeecg</groupId> <artifactId>easypoi-base</artifactId> <version>2.3.1</version> </dependency> <!--easypoi-web 耦合了spring-mvc 基于AbstractView,极大的简化spring-mvc下的导出功能--> <dependency> <groupId>org.jeecg</groupId> <artifactId>easypoi-web</artifactId> <version>2.3.1</version> </dependency> <!--easypoi-annotation 基础注解包,作用与实体对象上,拆分后方便maven多工程的依赖管理--> <dependency> <groupId>org.jeecg</groupId> <artifactId>easypoi-annotation</artifactId> <version>2.3.1</version> </dependency>

2、导出功能

controller层：

@RequestMapping("/downloadExcel") public void download(HttpServletRequest request, HttpServletResponse response) throws Exception { // 告诉浏览器用什么软件可以打开此文件 response.setHeader("content-Type", "application/vnd.ms-excel"); // 下载文件的默认名称 response.setHeader("Content-Disposition", "attachment;filename=" + URLEncoder.encode("用户数据表","UTF-8") + ".xls"); //编码 response.setCharacterEncoding("UTF-8"); List<User> list = userService.findAllUser();//获得用户 Workbook workbook = ExcelExportUtil.exportExcel(new ExportParams(), User.class, list); workbook.write(response.getOutputStream()); }

service层：

@Override public List<User> findAllUser() { return userMapper.findAllUser(); }

dao层：

<select id="findAllUser" resultMap="user"> SELECT id,name FROM t_user </select>

3、导入功能

controller层：

@RequestMapping("/excelImport") @ResponseBody public String excelImport() { ImportParams importParams = new ImportParams(); ImportParams params = new ImportParams(); params.setHeadRows(2);   try { List<User> objects = ExcelImportUtil.importExcel(new File("F:\\aa.xls"), User.class, importParams); userService.importUser(objects); System.out.println(objects); return "ok"; }catch (Exception e){ e.printStackTrace(); return "no";   }   }

service层：

/** * 导入User * @param objects */ @Override public void importUser(List<User> objects) {   for (User user : objects) { userMapper.importUser(user); }     }

dao层：

<insert id="importUser" parameterType="cn.itfeiyue.itfeiyuemybatis.pojo.User"> INSERT INTO t_user(name) VALUES(#{name}) </insert>