EasyExcel分次插入Excel

 @GetMapping("/muiltAppend")
    public String muiltAppend() {
        String filename = "multi_append_data.xlsx";
        // 创建ExcelWriter对象
        ExcelWriter excelWriter = EasyExcel.write(filename,User.class).build();

        // 创建WriteSheet对象
        WriteSheet writeSheet = EasyExcel.writerSheet(0).build();

        // 循环多次追加数据
        for (int i = 1; i <= 3; i++) {
            List<User> data = userService.getPageList(i, 2).getRecords();
            // 追加数据到Excel文件
            excelWriter.write(data, writeSheet);
        }

        // 完成数据追加
        excelWriter.finish();
        System.out.println("Data appended to " + filename);
        return "SUCCESS";
    }