1.引入架包
<dependency><groupId>cn.afterturn</groupId><artifactId>easypoi-base</artifactId><version>4.2.0</version>
</dependency>
<dependency><groupId>org.apache.poi</groupId><artifactId>poi</artifactId><version>4.1.1</version>
</dependency>
<dependency><groupId>org.apache.poi</groupId><artifactId>poi-ooxml</artifactId><version>4.1.1</version>
</dependency>

创建 excel模板

controller 导出 导出只需要controller层代码

List<YrsSewageDrainingExit> list = yrsSewageDrainingExitService.selectYrsSewageDrainingExitList(yrsSewageDrainingExit);
// 模板路径String path = System.getProperty("user.dir") + "\\doc\\黄河流域入河排污口设置审核名录.xlsx";TemplateExportParams temp = new TemplateExportParams(path);HashMap<String, Object> map = new HashMap<>();map.put("maplist", list);Workbook workbook = ExcelExportUtil.exportExcel(temp, map);if (workbook == null) {return new AjaxResult();}
// 设置excel的文件名称String fileName = "黄河流域入河排污口设置审核名录" + ".xlsx";String exportPath = "D:\\ruoyi\\uploadPath\\download\\" + fileName;try (FileOutputStream fops = new FileOutputStream(exportPath);) {workbook.write(fops);} catch (Exception e) {e.printStackTrace();}return AjaxResult.success(fileName);

导入controller

        ImportParams params = new ImportParams();params.setTitleRows(1);// 从那行表头开始params.setHeadRows(4);List<YrsSewageDrainingExit> yrsSewageDrainingExits = ExcelImportUtil.importExcel(file.getInputStream(), YrsSewageDrainingExit.class, params);LoginUser loginUser = tokenService.getLoginUser(ServletUtils.getRequest());String operName = loginUser.getUsername();String message = yrsSewageDrainingExitService.importUser(yrsSewageDrainingExits, updateSupport, operName);return AjaxResult.success(message);

 导入功能serviceimpl

if (StringUtils.isNull(yrsSewageDrainingExit) || yrsSewageDrainingExit.size() == 0) {throw new CustomException("导入用户数据不能为空！");}int successNum = 0;int failureNum = 0;StringBuilder successMsg = new StringBuilder();StringBuilder failureMsg = new StringBuilder();String password = configService.selectConfigByKey("sys.user.initPassword");for (YrsSewageDrainingExit yrsProvincePaikou : yrsSewageDrainingExit) {try {this.insertYrsSewageDrainingExit(yrsProvincePaikou);successNum++;successMsg.append("<br/>" + successNum + "、账号 " + yrsProvincePaikou.getSeName() + " 导入成功");} catch (Exception e) {failureNum++;String msg = "<br/>" + failureNum + "、账号 " + yrsProvincePaikou.getSeName() + " 导入失败：";failureMsg.append(msg + e.getMessage());log.error(msg, e);}}if (failureNum > 0) {failureMsg.insert(0, "很抱歉，导入失败！共 " + failureNum + " 条数据格式不正确，错误如下：");throw new CustomException(failureMsg.toString());} else {successMsg.insert(0, "恭喜您，数据已全部导入成功！共 " + successNum + " 条，数据如下：");}return successMsg.toString();

模板导出

File file = new File(System.getProperty("user.dir") + "\\doc\\黄河流域入河排污口设置审核名录模板.xlsx");if (!file.exists()) {return AjaxResult.error("文件不存在");}BufferedInputStream br = new BufferedInputStream(new FileInputStream(file));byte[] buf = new byte[1024];int len = 0;// 设置excel的文件名称String fileName = "黄河流域入河排污口设置审核名录模板" + ".xlsx";String exportPath = "D:\\ruoyi\\uploadPath\\download\\" + fileName;try (FileOutputStream fops = new FileOutputStream(exportPath);) {while ((len = br.read(buf)) > 0) {fops.write(buf, 0, len);}br.close();fops.close();} catch (Exception e) {e.printStackTrace();}return AjaxResult.success(fileName);

写好的模板放到文件夹中 导出模版时会把这个表格直接导出

这样就完成了！