使用hutool读取excel多sheet文件

首先要使用hutool，可以加载maven

 		<dependency>
            <groupId>com.xiaoleilu</groupId>
            <artifactId>hutool-all</artifactId>
            <version>3.3.2</version>
        </dependency>

Controller使用方法

@ApiOperation(value = "导入excel员工")
    @ResponseBody
    @RequestMapping(value = "/importExcelEmp_1", method = RequestMethod.POST)
    public ResponseVal importExcelEmp(HttpServletRequest request,
                                      @RequestParam(value = "file", required = false) MultipartFile files, String comId) {


        //DateFormat formater = new SimpleDateFormat("yyyy/MM/dd");
        try{
            //默认获取第一页
            ExcelReader reader = ExcelUtil.getReader(files.getInputStream());
            List<Map<String,Object>> readAll = reader.read(1,2,Integer.MAX_VALUE);
            for (Map<String,Object> s:readAll) {
                for (String k : s.keySet())
                {
                    System.out.println("基本信息:"+k + " : " + s.get(k));
                }
            }
            ExcelReader reader1 = ExcelUtil.getReader(files.getInputStream(), "教育经历");
            /**
             * headerRowIndex 标题所在行，如果标题行在读取的内容行中间，这行做为数据将忽略
             * @param startRowIndex 起始行（包含，从0开始计数）
             */
            List<Map<String,Object>> readAlls = reader1.read(1,2,Integer.MAX_VALUE);
            for (Map<String,Object> s:readAlls) {
                for (String k : s.keySet())
                {
                    System.out.println("教育经历："+k + " : " + s.get(k));
                }
            }
        }catch (IOException e){
            e.printStackTrace();
        }
        return null;
    }