Java | 解析Excel 实现批量上传

Java解析Excel 实现批量上传

@RequestMapping(value = "/importWorkRecordsExcel")
@ResponseBody
public String upload(HttpServletRequest request, HttpServletResponse response) throws Exception {
   
   SerParameter serParameter = new SerParameter();
   Map<String, Object> resultMap = new HashMap<String, Object>();
   try {
   
      Map<String, Object> parseResult = parseExcel(request);
         //文件名
      String fileName = (String) parseResult.get("FILE_NAME");
        //excel文件解析后的ListMap
      List<Map<String, String>> excelData = (List<Map<String, String>>) parseResult.get("EXCEL_DATA");
        // ......保存数据的方法
}

private Map<String, Object> parseExcel(HttpServletRequest request) throws Exception {
   
   Map<String, Object> parseResult = new HashMap<String, Object>();
   List<Map<String, Object>> excelData = null;
   boolean isMultipart = ServletFileUpload.isMultipartContent(request);
   CommonsMultipartResolver multipartResolver = new CommonsMultipartResolver(request.getSession().getServletContext());
   if(multipartResolver