Excel多表数据批量导出出现空格排序情况

                                       **大神们给指点一下迷境**

img


 //新增数据行,并且设置单元格数据
        int rowNum = 1;
        List oneManySub01s = null;
        List oneManySub02s = null;
//主表
         for (OneManyMain excelUser : classmateList) {
            HSSFRow  row1 = sheet.createRow(rowNum);
            //判断lastName是否为null  若为null 给空  若不为null 传相应的值
            if (excelUser.getId() == null) {
                row1.createCell(0).setCellValue("");
            } else {
                row1.createCell(0).setCellValue(excelUser.getId().toString());
            }
            rowNum++;
            oneManySub01s = excelUser.getOneManySub01s();
            oneManySub02s = excelUser.getOneManySub02s();
        }
        //表1
        for (OneManySub01 manySub01 : oneManySub01s) {
            HSSFRow row2 = sheet.createRow(rowNum);
            if (manySub01.getBaid() == null) {
                row2.createCell(9).setCellValue("");
            } else {
                row2.createCell(9).setCellValue(manySub01.getBaid().toString());
            }
            rowNum++;
        }
        //表2
        for (OneManySub02 sub02 : oneManySub02s) {
            HSSFRow row3 = sheet.createRow(rowNum);
            if (sub02.getBbid() == null) {
                row3.createCell(14).setCellValue("");
            } else {
                row3.createCell(14).setCellValue(sub02.getBbid().toString());
            }
            rowNum++;
        }

你这程序就是这么写的啊,每次都接着上一个表的rownum加一,