SSM框架使用poi导入导出Excel的详细方法 SSM框架使用poi导入导出Excel的详

1.首先我们先导入poi和文件上传的依赖

org.apache.poipoi-ooxml-schemas3.14-beta1commons-fileuploadcommons-fileupload1.2.2commons-iocommons-io2.4

2.在spring-mvc.xml中配置文件上传解析器

5242880

3.创建index.html

导出

4.创建实体类

public class User {private Integer id; private String username; private String password; /* get 和 set */}

5.Controller层

/*** 导出Excel* @param request* @param response*/@RequestMapping("/exportExcel")@ResponseBodypublic void exportExcel(HttpServletRequest request, HttpServletResponse response){try {//获取数据源List userList = service.queryUserAll(); //导出excelresponse.setHeader("Content-Disposition","attachment; filename="+new String("用户信息.xls".getBytes(),"ISO-8859-1")); response.setContentType("application/x-excel; charset=UTF-8"); OutputStream outputStream = response.getOutputStream(); //导出service.exportExcel(userList,outputStream); outputStream.close(); } catch (IOException e) {e.printStackTrace(); }}

/*** 导入exc* @param userExcel* @param request* @param session* @return*/@RequestMapping("/importExcel")@ResponseBodypublic String importExcel(MultipartFile userExcel, HttpServletRequest request, HttpSession session) throws IOException, InvalidFormatException {if(userExcel == null){session.setAttribute("excelName", "未上传文件，上传失败！"); return null; }String userExcelFileName = userExcel.getOriginalFilename(); if(!userExcelFileName.matches("^.+\\.(?i)((xls)|(xlsx))$")){session.setAttribute("excelName", "文件格式不正确！请使用.xls或.xlsx后缀的文档，导入失败！"); return null; }//导入service.importExcel(userExcel); session.setAttribute("excelName", "导入成功！"); return "redirect:queryUserAll.do"; }

6.运行测试