EasyExcel写入多个sheet

最新推荐文章于 2024-05-11 15:41:13 发布

珠峰下的沙砾

最新推荐文章于 2024-05-11 15:41:13 发布

阅读量1.3k

点赞数 9

分类专栏： EasyExcel 文章标签： java

本文链接：https://blog.csdn.net/qq_43072399/article/details/134759622

版权

EasyExcel 专栏收录该内容

4 篇文章 0 订阅

订阅专栏

在这里插入图片描述

直接上代码：

    public static void main(String[] args) {

        // 设置excel工作簿
        ExcelWriter excelWriter = EasyExcel.write("F:\\excel\\a.xls")
                .build();

        List<User> userList = new ArrayList<>();
        userList.add(new User("lisi", "12"));
        userList.add(new User("wangWu", "15"));
        userList.add(new User("zhaoLiu", "22"));
        ExcelWriterSheetBuilder userExcelSheet = new ExcelWriterSheetBuilder();
        userExcelSheet.sheetName("学生信息");
        userExcelSheet.sheetNo(0);
        excelWriter.write(userList, userExcelSheet.build());


        List<ClassInfo> classInfoList = new ArrayList<>();
        classInfoList.add(new ClassInfo("1班", "22"));
        classInfoList.add(new ClassInfo("2班", "32"));
        ExcelWriterSheetBuilder classExcelSheet = new ExcelWriterSheetBuilder();
        classExcelSheet.sheetName("班级信息");
        classExcelSheet.sheetNo(1);
        excelWriter.write(classInfoList, classExcelSheet.build());

        excelWriter.finish();
    }