第一步获取的数据,因为我这边需要根据 车牌号 合并单元格,我分别定义了两个值,jinnanMap,jinnanMap1,以后最对比
List<Map<String,Object>> downLoad=wOutBoundSubMapper.selOutBoundDownList(createTimeStart,
createTimeEnd,batchNumber,heatNumber,bundleNumber,loadedNumber,carNumber,contractNumber,outboundNumber);
for(int i=0;i<downLoad.size();i++){
row = sheet.createRow(i +1);
Map<String, Object> jinNanMap=downLoad.get(i);
Map<String, Object> jinNanMap1=null;
if(i>=1){
jinNanMap1=downLoad.get(i-1);
}
}
上面我对数据进行set后,最后一行相同数据的不会合并。思绪太乱了
if(jinNanMap1!=null){
if (jinNanMap.get("carNumber").toString().equals(jinNanMap1.get("carNumber").toString())) {
}else {
for(int j=0;j<=jinNanMap1.size();j++) {
if(startrow==i){
break;
}
if (j<1){
sheet.addMergedRegion(new CellRangeAddress(startrow, i, j, j));
}
}
startrow = i+1;
}
}
if(jinNanMap1!=null){
if(i==downLoad.size()-1){
for(int j=0;j<=jinNanMap1.size();j++) {
if(startrow==i){
if (j<jinNanMap1.size()+1){
sheet.addMergedRegion(new CellRangeAddress(startrow, i+1, j, j));
}
break;
}
}
}
}
实在是没思路了。不知道咋整了