int [] field_arr ={0,1,6,7,8,9}; //要合并的数据为那几列
for(int m =0;m <field_arr.length;m++){
int field = field_arr[m];
int begin =1;
int end =1;
int onId =0;
int type =0; //根据类型判断的参数
for(int j =0;j<rest.size();j++){
List<Object> vou = (List<Object>) rest.get(j);
int begin1 =1;
begin1 =begin;
int end1 =1;
if(type ==0) {
onId =Integer.parseInt( vou.get(10).toString());
type =1;
end ++;
if(end ==rest.size()+1){
end1 =end-1;
hssfSheet.addMergedRegion(new CellRangeAddress(begin1, end1, field, field));
}
} else {
int onlyId1 = Integer.parseInt( vou.get(10).toString());//当前的onlyId
if(onlyId1==onId ) {
end++;
}
else {
end1 =end-1;
hssfSheet.addMergedRegion(new CellRangeAddress(begin1, end1, field, field));
begin =end++;
end =end++;
type =0; //设置type=0 然后给onlyId 重新赋值
}
}
}
}
版权声明:本文为a863922230原创文章,遵循CC 4.0 BY-SA版权协议,转载请附上原文出处链接和本声明。