导出excel添加用户id

peng

2025-10-22 b9b8b93a1b8ec1954ffc690093cb4628477de8c2

 framework/src/main/java/cn/lili/modules/member/serviceimpl/MemberServiceImpl.java

@@ -734,6 +734,7 @@
        // 创建表头
        Row header = sheet.createRow(0);
        String[] headers = {
                "会员id",
                "会员名称", "会员昵称","联系方式",
                "注册时间","最后登录时间"
        };
@@ -744,11 +745,12 @@
        for (int i=0;i< exportDetailDTOS.size();i++){
            MemberExportVO dto = exportDetailDTOS.get(i);
            Row row = sheet.createRow(i+1);
            row.createCell(0).setCellValue(dto.getUsername());
            row.createCell(1).setCellValue(dto.getNickName());
            row.createCell(2).setCellValue(dto.getMobile());
            row.createCell(3).setCellValue(dto.getCreateTime());
            row.createCell(4).setCellValue(dto.getLastLoginDate());
            row.createCell(0).setCellValue(dto.getId());
            row.createCell(1).setCellValue(dto.getUsername());
            row.createCell(2).setCellValue(dto.getNickName());
            row.createCell(3).setCellValue(dto.getMobile());
            row.createCell(4).setCellValue(dto.getCreateTime());
            row.createCell(5).setCellValue(dto.getLastLoginDate());
        }

        return workbook;