**大神们给指点一下迷境**
//新增数据行,并且设置单元格数据
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加一,