求助贴！救救我！我的Java的POI对Excel进行相同单元格合并的代码到底怎么改?!

已于 2024-07-17 11:29:43 修改
阅读量399 收藏 4
点赞数 8
文章标签： java excel 开发语言
于 2024-07-17 11:15:33 首次发布
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/zw45607076875/article/details/140488119
版权

一个作业,要求我们把用Java的POI把一个表的数据导入,并导出成一个新的按格式要求Excel表

作业要求:

 我的代码如下,一个是主类,一个是实体类

我的主类:


 

package Excel;

import org.apache.poi.ss.usermodel.*;
import org.apache.poi.ss.util.CellRangeAddress;
import org.apache.poi.xssf.streaming.SXSSFCell;
import org.apache.poi.xssf.streaming.SXSSFRow;
import org.apache.poi.xssf.streaming.SXSSFSheet;
import org.apache.poi.xssf.streaming.SXSSFWorkbook;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;

import java.io.*;
import java.util.*;

public class excelHomework2 {
    public static void main(String[] args) throws FileNotFoundException {
        Map<String, List<WorkerInfo>> map = excel(new FileInputStream("D:\\作业.xlsx"));//导入数据
        exportExcel(map, "D:\\杨慧成果.xlsx");//导出数据
    }

    private static Map<String, List<WorkerInfo>> excel(FileInputStream path) {
        Map<String, List<WorkerInfo>> map = new HashMap<>();//map在外面,因为只有一个文件

        try {
            Workbook workbook = new XSSFWorkbook(path);
            int sheetNumber = workbook.getNumberOfSheets();
            for (int i = 0; i < sheetNumber; i++) {
                Sheet sheet = workbook.getSheetAt(i);
                String sheetName = sheet.getSheetName();
                List<WorkerInfo> workerList = new ArrayList<>();//list在里面,因为有多个表

                int firstNumber = sheet.getFirstRowNum() + 2;
                int lastNumber = sheet.getLastRowNum();

                for (int rowNum = firstNumber; rowNum <= lastNumber; rowNum++) {
                    WorkerInfo workerInfo = new WorkerInfo();
                    Row row = sheet.getRow(rowNum);//行

                    Cell cell0 = row.getCell(0);//获取列
//                    System.out.println("序号" + getCellValue(cell0));//获取值
                    workerInfo.setNumber(getCellValue(cell0));

                    Cell cell1 = row.getCell(1);//获取列
//                    System.out.println("姓名" + getCellValue(cell1));//获取值
                    workerInfo.setName(getCellValue(cell1));

                    Cell cell2 = row.getCell(2);//获取列
//                    System.out.println("性别" + getCellValue(cell2));//获取值
                    workerInfo.setSex(getCellValue(cell2));

                    Cell cell3 = row.getCell(3);//获取列
//                    System.out.println("身份证号" + getCellValue(cell3));//获取值
                    workerInfo.setID(getCellValue(cell3));

                    Cell cell4 = row.getCell(4);//获取列
//                    System.out.println("手机号" + getCellValue(cell4));//获取值
                    workerInfo.setPhone(getCellValue(cell4));

                    Cell cell5 = row.getCell(5);//获取列
//                    System.out.println("银行卡号" + getCellValue(cell5));//获取值
                    workerInfo.setBankcard(getCellValue(cell5));

                    Cell cell6 = row.getCell(6);//获取列
//                    System.out.println("开户银行支行" + getCellValue(cell6));//获取值
                    workerInfo.setDepositBank(getCellValue(cell6));

                    Cell cell7 = row.getCell(7);//获取列
//                    System.out.println("岗位" + getCellValue(cell7));//获取值
                    workerInfo.setJob(getCellValue(cell7));

                    Cell cell8 = row.getCell(8);//获取列
//                    System.out.println("参与项目日期" + getCellValue(cell8));//获取值
                    workerInfo.setPartTime(getCellValue(cell8));

                    Cell cell9 = row.getCell(9);//获取列
//                    System.out.println("项目" + getCellValue(cell9));//获取值
                    workerInfo.setProject(getCellValue(cell9));

                    Cell cell10 = row.getCell(10);//获取列
//                    System.out.println("薪酬" + getCellValue(cell10));//获取值
                    workerInfo.setSalary(getCellValue(cell10));

                    workerList.add(workerInfo);

                }
                map.put(sheetName, workerList);
            }

        } catch (Exception e) {
            e.printStackTrace();
        }

        return map;
    }


    /**
     * 导出excel
     *
     * @param
     * @param
     */
    private static void exportExcel(Map<String, List<WorkerInfo>> mapOfData, String path) {
        try {
            Workbook wb = new SXSSFWorkbook();

            //标题单元格
            Sheet sheet = wb.createSheet("CRM");
            Row rowTitle1 = sheet.createRow(0);
            Cell titleCell1 = rowTitle1.createCell(0);
            titleCell1.setCellValue("CRM本月工资绩效表");
            for (int i = 0; i < 11; i++) {
                sheet.setColumnWidth(i, 35 * 256);
            }
            rowTitle1.setHeightInPoints(100);
            //标题单元格

            sheet.addMergedRegion(new CellRangeAddress(0, 0, 0, 10));
            sheet.addMergedRegion(new CellRangeAddress(1, 1, 9, 10));

            //样式
            CellStyle styleOfnum0 = wb.createCellStyle();
            styleOfnum0.setAlignment(HorizontalAlignment.CENTER);
            styleOfnum0.setVerticalAlignment(VerticalAlignment.CENTER);
            styleOfnum0.setFillForegroundColor(IndexedColors.RED.getIndex());
            styleOfnum0.setFillPattern(FillPatternType.SOLID_FOREGROUND);

            CellStyle styleOfnum1 = wb.createCellStyle();
            styleOfnum1.setAlignment(HorizontalAlignment.CENTER);
            styleOfnum1.setVerticalAlignment(VerticalAlignment.CENTER);
            styleOfnum1.setFillForegroundColor(IndexedColors.GREEN.getIndex());
            styleOfnum1.setFillPattern(FillPatternType.SOLID_FOREGROUND);

            CellStyle styleOfnum2 = wb.createCellStyle();
            styleOfnum2.setAlignment(HorizontalAlignment.CENTER);
            styleOfnum2.setVerticalAlignment(VerticalAlignment.CENTER);
            styleOfnum2.setFillForegroundColor(IndexedColors.YELLOW.getIndex());
            styleOfnum2.setFillPattern(FillPatternType.SOLID_FOREGROUND);

            CellStyle styleOfnum3 = wb.createCellStyle();
            styleOfnum3.setAlignment(HorizontalAlignment.CENTER);
            styleOfnum3.setVerticalAlignment(VerticalAlignment.CENTER);
            styleOfnum3.setFillForegroundColor(IndexedColors.GREY_40_PERCENT.getIndex());
            styleOfnum3.setFillPattern(FillPatternType.SOLID_FOREGROUND);

            CellStyle styleOfnum4 = wb.createCellStyle();
            styleOfnum4.setAlignment(HorizontalAlignment.CENTER);
            styleOfnum4.setVerticalAlignment(VerticalAlignment.CENTER);
            CellStyle cellStyle = wb.createCellStyle();


            cellStyle.setFillForegroundColor(IndexedColors.RED.getIndex());//设置背景颜色
            cellStyle.setFillPattern(FillPatternType.SOLID_FOREGROUND);//设置填充颜色
            cellStyle.setAlignment(HorizontalAlignment.CENTER);//居中
            cellStyle.setVerticalAlignment(VerticalAlignment.CENTER);
            //字体
            Font font = wb.createFont();
            font.setBold(true);//是否加粗
            font.setFontName("黑体");
            styleOfnum0.setFont(font);
            styleOfnum1.setFont(font);
            styleOfnum2.setFont(font);
            styleOfnum3.setFont(font);
            styleOfnum4.setFont(font);

            cellStyle.setFont(font);//把字体放在样式中
            titleCell1.setCellStyle(cellStyle);//设置单元格样式
            //字体

            //样式



            String[] title1 = {"项目", "薪资"};
            Row row1 = sheet.createRow(2);
            for (int i = 0; i < title1.length; i++) {
                Cell temcell = row1.createCell(i + 9);
                temcell.setCellValue(title1[i]);
                temcell.setCellStyle(styleOfnum3);
            }
            String[] title = {"序号", "姓名", "性别", "身份证号", "手机号", "银行卡号", "开户银行支行", "岗位", "参与项目日期", "2024年5月"};
            Row row = sheet.createRow(1);
            for (int i = 0; i < title.length; i++) {
                Cell temcell = row.createCell(i);
                temcell.setCellValue(title[i]);
                if (i == 0) {
                    temcell.setCellStyle(styleOfnum0);
                } else if (i == 1) {
                    temcell.setCellStyle(styleOfnum1);
                } else if (i == 2) {
                    temcell.setCellStyle(styleOfnum2);
                } else {
                    temcell.setCellStyle(styleOfnum3);
                }
                if (i <= title.length - 2) {
                    sheet.addMergedRegion(new CellRangeAddress(1, 2, i, i));
                }
            }



            Set<String> set = mapOfData.keySet();
            Double sum = 0.0;
            for (String s : set) {
                List<WorkerInfo> listOfworkers = mapOfData.get(s);
                int i = 3;
                for (WorkerInfo worker : listOfworkers) {
                    Row temrow = sheet.createRow(i++);

                    for (int j = 0; j < 11; j++) {
                        String temvalue = "";
//                            System.out.println("i:" + i + " " + "j：" + j);
                        switch (j) {
                            case 0:
                                temvalue = worker.getNumber();
//                                    System.out.println(worker.getNumber());
                                break;
                            case 1:
                                temvalue = worker.getName();
//                                    System.out.println(worker.getName());
                                break;
                            case 2:
                                temvalue = worker.getSex();
//                                    System.out.println(worker.getSex());

                                break;
                            case 3:
                                temvalue = worker.getID();
//                                    System.out.println(worker.getID());
                                break;
                            case 4:
                                temvalue = worker.getPhone();
//                                    System.out.println(worker.getPhone());
                                break;
                            case 5:
                                temvalue = worker.getBankcard();
                                break;
                            case 6:
                                temvalue = worker.getDepositBank();
                                break;
                            case 7:
                                temvalue = worker.getJob();
                                break;
                            case 8:
                                temvalue = worker.getPartTime();
                                break;
                            case 9:
                                temvalue = worker.getProject();
                                break;
                            case 10:
                                sum += Double.valueOf(worker.getSalary());
                                temvalue = worker.getSalary();
                                break;
                        }

                        Cell temcell = temrow.createCell(j);
                        temcell.setCellValue(temvalue);
//                        System.out.println(temvalue);

                    }

                }
            }


            System.out.println(sheet.getLastRowNum());
            Row addUprow = sheet.createRow(sheet.getLastRowNum() + 1);
            Cell addUpcell = addUprow.createCell(0);
            addUpcell.setCellValue("合计");
            addUprow.setHeightInPoints(50);
            addUpcell.setCellStyle(styleOfnum4);
            sheet.addMergedRegion(new CellRangeAddress(addUpcell.getRowIndex(), addUpcell.getRowIndex(), addUpcell.getColumnIndex(), addUpcell.getColumnIndex() + 9));
            addUprow.createCell(10).setCellValue(sum);

            int last=sheet.getRow(2).getLastCellNum();
            for (int i = 0; i <last ; i++) {
                String s = "";
                int start = 3;
                int end = 3;
                for (int j = 3; j < sheet.getLastRowNum(); j++) {
                    Row temrow = sheet.getRow(j);
                    Cell cell = temrow.getCell(i);
                    if (j == 3) {
                        s = cell.getStringCellValue();
                        System.out.println("第" + i + "列的合并情况如下:");
                        continue;
                    }
                    if (cell.getStringCellValue().equals(s)) {
                        end++;
                    } else {//当遇到不同的数据时(但是如果一直都是相同数据),相同到底的话,这个方法就没用了):如果是在连续相同的情况下,如果是在连续不同的情况下
                        System.out.print("有一个数据不同la!");
                        s = cell.getStringCellValue();
                        if (start != end) {
                            sheet.addMergedRegion(new CellRangeAddress(start, end, cell.getColumnIndex(), cell.getColumnIndex()));
                            end++;
                            start = end;
//                                System.out.print("合并了一个");
//                                System.out.println("start:"+start+"end:"+end);
                        } else {
                            start++;
                            end++;
                        }
                    }
                    System.out.println("end:" + end);
                }
            }

            FileOutputStream fileOutputStream = new FileOutputStream(path);
            wb.write(fileOutputStream);
            fileOutputStream.close();
            wb.close();


        } catch (Exception e) {
            e.printStackTrace();
        }

    }

    private static String getCellValue(Cell cell) {
        String value = "";
        DataFormatter dataFormatter = new DataFormatter();
        if (cell == null) {
            System.out.println("单元格为空");
            return "空";
        }

        value = dataFormatter.formatCellValue(cell);//
        return value;
    }


}

我的实体类:


package Excel;

class WorkerInfo {
    private String Number;
    private String Name;
    private String Sex;
    private String ID;
    private String Phone;
    private String Bankcard;
    private String DepositBank;
    private String Job;
    private String PartTime;
    private String Project;
    private String Salary;

    public WorkerInfo() {
    }

    public WorkerInfo(String number, String name, String sex, String ID, String phone, String bankcard, String depositBank, String job, String partTime, String project, String salary) {
        Number = number;
        Name = name;
        Sex = sex;
        this.ID = ID;
        Phone = phone;
        Bankcard = bankcard;
        DepositBank = depositBank;
        Job = job;
        PartTime = partTime;
        Project = project;
        Salary = salary;
    }

    public String getNumber() {
        return Number;
    }

    public void setNumber(String number) {
        Number = number;
    }

    public String getName() {
        return Name;
    }

    public void setName(String name) {
        Name = name;
    }

    public String getSex() {
        return Sex;
    }

    public void setSex(String sex) {
        Sex = sex;
    }

    public String getID() {
        return ID;
    }

    public void setID(String ID) {
        this.ID = ID;
    }

    public String getPhone() {
        return Phone;
    }

    public void setPhone(String phone) {
        Phone = phone;
    }

    public String getBankcard() {
        return Bankcard;
    }

    public void setBankcard(String bankcard) {
        Bankcard = bankcard;
    }

    public String getDepositBank() {
        return DepositBank;
    }

    public void setDepositBank(String depositBank) {
        DepositBank = depositBank;
    }

    public String getJob() {
        return Job;
    }

    public void setJob(String job) {
        Job = job;
    }

    public String getPartTime() {
        return PartTime;
    }

    public void setPartTime(String partTime) {
        PartTime = partTime;
    }

    public String getProject() {
        return Project;
    }

    public void setProject(String project) {
        Project = project;
    }

    public String getSalary() {
        return Salary;
    }

    public void setSalary(String salary) {
        Salary = salary;
    }
}

我的问题:


其中出现问题的是exportExcel中的代码(如下),这是在遍历每列的每行的单元格,为了让垂直相邻相同的单元格合并:

     int last=sheet.getRow(2).getLastCellNum();
            for (int i = 0; i <last ; i++) {
                String s = "";
                int start = 3;
                int end = 3;
                for (int j = 3; j < sheet.getLastRowNum(); j++) {
                    Row temrow = sheet.getRow(j);
                    Cell cell = temrow.getCell(i);
                    if (j == 3) {
                        s = cell.getStringCellValue();
                        System.out.println("第" + i + "列的合并情况如下:");
                        continue;
                    }
                    if (cell.getStringCellValue().equals(s)) {
                        end++;
                    } else {//当遇到不同的数据时(但是如果一直都是相同数据),相同到底的话,这个方法就没用了):如果是在连续相同的情况下,如果是在连续不同的情况下
                        System.out.print("有一个数据不同la!");
                        s = cell.getStringCellValue();
                        if (start != end) {
                            sheet.addMergedRegion(new CellRangeAddress(start, end, cell.getColumnIndex(), cell.getColumnIndex()));
                            end++;
                            start = end;
//                                System.out.print("合并了一个");
//                                System.out.println("start:"+start+"end:"+end);
                        } else {
                            start++;
                            end++;
                        }
                    }
                    System.out.println("end:" + end);
                }
            }

  正确示例:

我的运行结果:

运行结果(表)如下:

只合并了一部分,没有全合并,例如项目那一列,合并了CRM,SFA,DMS，但是没有合并CS
其他列也是这样，只要需要合并到最后一行，那就无法合并，但是我不知道怎么改代码。。。救救我 
表如下:

CRM本月工资绩效表
序号姓名性别身份证号手机号银行卡号开户银行支行岗位参与项目日期2024年5月
项目薪资
1test1男360733200112111111151802201516216606500020646041中国银行新余市分行JAVA实习2023"年"4"月"17"日"CRM7500.0
2test2女360733200112111112159708614206216606500020646042中国建设银行股份有限公司新余渝水支行2023"年"4"月"17"日"7000.0
3test3男360733200112111113159708614216216606500020646043中国建设银行股份有限公司新余渝水支行WEB前端2023"年"4"月"17"日"9500.0
4test4360733200112111111159708614226216606500020646041中国建设银行股份有限公司新余渝水支行WEB前端2023"年"4"月"17"日"12000.0
5test5女360733200112111112159708614236216606500020646042中国建设银行股份有限公司新余渝水支行WEB前端2023"年"4"月"17"日"14500.0
6test6男360733200112111113159708614246216606500020646043中国建设银行股份有限公司新余渝水支行WEB前端2023"年"4"月"17"日"17000.0
7test7360733200112111111159708614256216606500020646041中国建设银行股份有限公司新余渝水支行WEB前端2023"年"4"月"17"日"19500.0
8test8女360733200112111112159708614266216606500020646042中国建设银行股份有限公司新余渝水支行WEB前端2023"年"4"月"17"日"22000.0
9test9男360733200112111113159708614276216606500020646043中国建设银行股份有限公司新余渝水支行WEB前端2023"年"4"月"17"日"24500.0
10test10360733200112111111159708614286216606500020646041中国建设银行股份有限公司新余渝水支行WEB前端2023"年"4"月"17"日"27000.0
11test11女360733200112111112159708614296216606500020646042中国建设银行股份有限公司新余渝水支行WEB前端2023"年"4"月"17"日"29500.0
12test12男360733200112111113159708614306216606500020646043中国建设银行股份有限公司新余渝水支行WEB前端2023"年"4"月"17"日"32000.0
13test13360733200112111111159708614316216606500020646041中国建设银行股份有限公司新余渝水支行WEB前端2023"年"4"月"17"日"34500.0
14test14女360733200112111112159708614326216606500020646042中国建设银行股份有限公司新余渝水支行WEB前端2023"年"4"月"17"日"37000.0
15test15男360733200112111113159708614336216606500020646043中国建设银行股份有限公司新余渝水支行WEB前端2023"年"4"月"17"日"39500.0
16test16360733200112111111159708614346216606500020646041中国建设银行股份有限公司新余渝水支行WEB前端2023"年"4"月"17"日"42000.0
17test17女360733200112111112159708614356216606500020646042中国建设银行股份有限公司新余渝水支行WEB前端2023"年"4"月"17"日"44500.0
18test18男360733200112111113159708614366216606500020646043中国建设银行股份有限公司新余渝水支行WEB前端2023"年"4"月"17"日"47000.0
19test19360733200112111111159708614376216606500020646041中国建设银行股份有限公司新余渝水支行WEB前端2023"年"4"月"17"日"49500.0
20test20女360733200112111112159708614386216606500020646042中国建设银行股份有限公司新余渝水支行WEB前端2023"年"4"月"17"日"52000.0
21test21男360733200112111113159708614396216606500020646043中国建设银行股份有限公司新余渝水支行WEB前端2023"年"4"月"17"日"54500.0
22test22360733200112111111159708614406216606500020646041中国建设银行股份有限公司新余渝水支行WEB前端2023"年"4"月"17"日"SFA57000.0
23test23女360733200112111112159708614416216606500020646042中国建设银行股份有限公司新余渝水支行WEB前端2023"年"4"月"17"日"59500.0
24test24男360733200112111113159708614426216606500020646043中国建设银行股份有限公司新余渝水支行WEB前端2023"年"4"月"17"日"62000.0
25test25360733200112111111159708614436216606500020646041中国建设银行股份有限公司新余渝水支行WEB前端2023"年"4"月"17"日"64500.0
26test26女360733200112111112159708614446216606500020646042中国建设银行股份有限公司新余渝水支行WEB前端2023"年"4"月"17"日"67000.0
27test27男360733200112111113159708614456216606500020646043中国建设银行股份有限公司新余渝水支行WEB前端2023"年"4"月"17"日"69500.0
28test28360733200112111111159708614466216606500020646041中国建设银行股份有限公司新余渝水支行WEB前端2023"年"4"月"17"日"72000.0
29test29女360733200112111112159708614476216606500020646042中国建设银行股份有限公司新余渝水支行WEB前端2023"年"4"月"17"日"74500.0
30test30男360733200112111113159708614486216606500020646043中国建设银行股份有限公司新余渝水支行WEB前端2023"年"4"月"17"日"77000.0
31test31360733200112111111159708614496216606500020646041中国建设银行股份有限公司新余渝水支行WEB前端2023"年"4"月"17"日"79500.0
32test32女360733200112111112159708614506216606500020646042中国建设银行股份有限公司新余渝水支行WEB前端2023"年"4"月"17"日"82000.0
33test33男360733200112111113159708614516216606500020646043中国建设银行股份有限公司新余渝水支行WEB前端2023"年"4"月"17"日"84500.0
34test34360733200112111111159708614526216606500020646041中国建设银行股份有限公司新余渝水支行WEB前端2023"年"4"月"17"日"87000.0
35test35女360733200112111112159708614536216606500020646042中国建设银行股份有限公司新余渝水支行WEB前端2023"年"4"月"17"日"DMS89500.0
36test36男360733200112111113159708614546216606500020646043中国建设银行股份有限公司新余渝水支行WEB前端2023"年"4"月"17"日"92000.0
37test37360733200112111111159708614556216606500020646041中国建设银行股份有限公司新余渝水支行WEB前端2023"年"4"月"17"日"94500.0
38test38女360733200112111112159708614566216606500020646042中国建设银行股份有限公司新余渝水支行WEB前端2023"年"4"月"17"日"97000.0
39test39男360733200112111113159708614576216606500020646043中国建设银行股份有限公司新余渝水支行WEB前端2023"年"4"月"17"日"99500.0
40test40360733200112111111159708614586216606500020646041中国建设银行股份有限公司新余渝水支行WEB前端2023"年"4"月"17"日"102000.0
41test41女360733200112111112159708614596216606500020646042中国建设银行股份有限公司新余渝水支行WEB前端2023"年"4"月"17"日"104500.0
42test42男360733200112111113159708614606216606500020646043中国建设银行股份有限公司新余渝水支行WEB前端2023"年"4"月"17"日"107000.0
43test43360733200112111111159708614616216606500020646041中国建设银行股份有限公司新余渝水支行WEB前端2023"年"4"月"17"日"109500.0
44test44女360733200112111112159708614626216606500020646042中国建设银行股份有限公司新余渝水支行WEB前端2023"年"4"月"17"日"112000.0
45test45男360733200112111113159708614636216606500020646043中国建设银行股份有限公司新余渝水支行WEB前端2023"年"4"月"17"日"114500.0
46test46360733200112111111159708614646216606500020646041中国建设银行股份有限公司新余渝水支行WEB前端2023"年"4"月"17"日"117000.0
47test47女360733200112111112159708614656216606500020646042中国建设银行股份有限公司新余渝水支行WEB前端2023"年"4"月"17"日"119500.0
48test48男360733200112111113159708614666216606500020646043中国建设银行股份有限公司新余渝水支行WEB前端2023"年"4"月"17"日"CS122000.0
49test49360733200112111111159708614676216606500020646041中国建设银行股份有限公司新余渝水支行WEB前端2023"年"4"月"17"日"CS124500.0
50test50女360733200112111112159708614686216606500020646042中国建设银行股份有限公司新余渝水支行WEB前端2023"年"4"月"17"日"CS127000.0
51test51男360733200112111113159708614696216606500020646043中国建设银行股份有限公司新余渝水支行WEB前端2023"年"4"月"17"日"CS129500.0
52test52360733200112111111159708614706216606500020646041中国建设银行股份有限公司新余渝水支行WEB前端2023"年"4"月"17"日"CS132000.0
53test53女360733200112111112159708614716216606500020646042中国建设银行股份有限公司新余渝水支行WEB前端2023"年"4"月"17"日"CS134500.0
54test54男360733200112111113159708614726216606500020646043中国建设银行股份有限公司新余渝水支行WEB前端2023"年"4"月"17"日"CS137000.0
55test55360733200112111111159708614736216606500020646041中国建设银行股份有限公司新余渝水支行WEB前端2023"年"4"月"17"日"CS139500.0
56test56女360733200112111112159708614746216606500020646042中国建设银行股份有限公司新余渝水支行WEB前端2023"年"4"月"17"日"CS142000.0
57test57男360733200112111113159708614756216606500020646043中国建设银行股份有限公司新余渝水支行WEB前端2023"年"4"月"17"日"CS144500.0
58test58360733200112111111159708614766216606500020646041中国建设银行股份有限公司新余渝水支行WEB前端2023"年"4"月"17"日"CS147000.0
59test59女360733200112111112159708614776216606500020646042中国建设银行股份有限公司新余渝水支行WEB前端2023"年"4"月"17"日"CS149500.0
60test60男360733200112111113159708614786216606500020646043中国建设银行股份有限公司新余渝水支行WEB前端2023"年"4"月"17"日"CS152000.0
61test61360733200112111111159708614796216606500020646041中国建设银行股份有限公司新余渝水支行WEB前端2023"年"4"月"17"日"CS154500.0
62test62女360733200112111112159708614806216606500020646042中国建设银行股份有限公司新余渝水支行WEB前端2023"年"4"月"17"日"CS157000.0
63test63男360733200112111113159708614816216606500020646043中国建设银行股份有限公司新余渝水支行WEB前端2023"年"4"月"17"日"CS159500.0
64test64360733200112111111159708614826216606500020646041中国建设银行股份有限公司新余渝水支行WEB前端2023"年"4"月"17"日"CS162000.0
65test65女360733200112111112159708614836216606500020646042中国建设银行股份有限公司新余渝水支行WEB前端2023"年"4"月"17"日"CS164500.0
66test66男360733200112111113159708614846216606500020646043中国建设银行股份有限公司新余渝水支行WEB前端2023"年"4"月"17"日"CS167000.0
67test67360733200112111111159708614856216606500020646041中国建设银行股份有限公司新余渝水支行WEB前端2023"年"4"月"17"日"CS169500.0
68test68女360733200112111112159708614866216606500020646042中国建设银行股份有限公司新余渝水支行WEB前端2023"年"4"月"17"日"CS172000.0
69test69男360733200112111113159708614876216606500020646043中国建设银行股份有限公司新余渝水支行WEB前端2023"年"4"月"17"日"CS174500.0
70test70360733200112111111159708614886216606500020646041中国建设银行股份有限公司新余渝水支行WEB前端2023"年"4"月"17"日"CS177000.0
71test71女360733200112111112159708614896216606500020646042中国建设银行股份有限公司新余渝水支行WEB前端2023"年"4"月"17"日"CS179500.0
72test72男360733200112111113159708614906216606500020646043中国建设银行股份有限公司新余渝水支行WEB前端2023"年"4"月"17"日"CS182000.0
73test73360733200112111111159708614916216606500020646041中国建设银行股份有限公司新余渝水支行WEB前端2023"年"4"月"17"日"CS184500.0
74test74女360733200112111112159708614926216606500020646042中国建设银行股份有限公司新余渝水支行WEB前端2023"年"4"月"17"日"CS187000.0
75test75男360733200112111113159708614936216606500020646043中国建设银行股份有限公司新余渝水支行WEB前端2023"年"4"月"17"日"CS189500.0
合计7278000

瑞金彭于晏
关注
  • 8
    点赞
  • 踩
  • 4
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值