Easypoi之excel多sheet导入

其他代码点击Easypoi之excel简单导入
controller层代码

 
    @RequestMapping(value = "multimports",method = RequestMethod.POST)
    @ResponseBody
    public String multimports(MultipartFile file) throws IOException {
        if (null==file){
            return GetResult.getResultObj("文件上传失败");
        }
        //根据file得到Workbook,主要是要根据这个对象获取,传过来的excel有几个sheet页
        Workbook hssfWorkbook = getWorkBook(file);
        //获取sheet数量
        int sheetNum = hssfWorkbook.getNumberOfSheets();
        importParams params = new importParams();
        //表头在第几行
        params.setTitleRows(5);
        try {
            List list = new ArrayList<>();
            for (int sheetIndex = 0; sheetIndex < sheetNum; sheetIndex++) {
                //第几个sheet页
                params.setStartSheetIndex(sheetIndex);
                List result = ExcelimportUtil.importExcel(file.getInputStream(), Applys.class, params);
                list.addAll(result);
            }
            for (int i = 0; i < list.size(); i++) {
                if (null==list.get(i).getRealName()){
                    list.remove(i);
                    i--;
                }
            }
            if (list.size()==0){
                return GetResult.getResultObj("数据读取失败，检查Excel数据格式");
            }
            if (ApplyService.saveBatch(list)){
                return GetResult.getResultObj("ok");
            }
        } catch (Exception e) {
            e.printStackTrace();
        }
        return GetResult.getResultObj("文件读取失败");
    }

    
    public static Workbook getWorkBook(MultipartFile file) throws IOException {
        //这样写excel能兼容03和07
        InputStream is = file.getInputStream();
        Workbook hssfWorkbook = null;
        try {
            hssfWorkbook = new HSSFWorkbook(is);
        } catch (Exception ex) {
            is =file.getInputStream();
            hssfWorkbook = new XSSFWorkbook(is);
        }
        return hssfWorkbook;
    }