【easypoi多sheet页导入】

甘露子

已于 2023-06-13 09:54:18 修改

阅读量432

点赞数 1

文章标签： java spring 开发语言

于 2023-06-13 09:43:52 首次发布

本文链接：https://blog.csdn.net/weixin_48912068/article/details/131181866

版权

   public List<Student> importTemplate(MultipartFile file) throws Exception {

        List<Student> studentList = new ArrayList<>();

        //获取sheet页的数量
        Workbook hssfWorkbook = new HSSFWorkbook(file.getInputStream());
        int sheetNum = hssfWorkbook.getNumberOfSheets();
        for (int sheetIndex = 0; sheetIndex < sheetNum; sheetIndex++) {
            ImportParams param = new ImportParams();
            //标题行数
            param.setTitleRows(0);
            //表头行数
            param.setHeadRows(1);
            //读取第几个sheet页
            param.setStartSheetIndex(sheetIndex);
            List<Student> students = ExcelImportUtil.importExcel(file.getInputStream(), Student.class, param);
            studentList.addAll(students);
        }
        return studentList;
    }